Excel Formula for Conditional Addition

Formula Explanation

To add 10% to a cell value based on the value in another cell being "Y", you can use the following formula:

Formula Syntax

=IF(A1="Y", B1*1.1, B1)

Components:

• IF Function: This function checks a condition and returns one value if it is TRUE and another value if it is FALSE.
  • Condition: A1="Y" checks if cell A1 contains "Y".
  • value_if_true: B1*1.1 calculates the value of B1 plus 10%.
  • value_if_false: B1 returns the original value of B1 if A1 does not contain "Y".

Practical Example

Assuming:

• Cell A1 contains the indicator (either "Y" or another value).
• Cell B1 contains a numerical value.

1. If A1 contains "Y" and B1 is 100:

   • The formula =IF(A1="Y", B1*1.1, B1) will return 110 (100 + 10%).

2. If A1 contains "N" and B1 is 100:

   • The same formula will return 100 because the condition is FALSE.

Conclusion

This formula effectively allows for a conditional increase of 10% on the value in cell B1 based on the presence of "Y" in cell A1, allowing for dynamic calculations based on user-defined criteria. For further development of your Excel skills, consider exploring the Enterprise DNA Platform courses.