IF statement

Question

I need to add % to a dollar amount based on the year before. How do I do an if statement. Example: if 2026=$25,891,151 and i want to add 3.26% for 2027. Need to take in account if 2026 =0

Answer 1

If the 2026 value is 0 you want to leave the 2027 value unchanged. That means the 2027 cell may contain a value. Therefore it doesn't contain a formula.

If the 2026 value is not 0, you want to compute the 2027 value based on the 2026 value, regardless of any existing value in the 2027 cell. That would normally require a formula in the 2027 cell but the cell may already contain a value.

The answer is a macro. You select the 2026 cell and invoke the macro. The macro checks the selected value and

• if 0, exits
• if non zero, computes the new value, stores it in the 2027 cell, and exits.

Answer 2

Hi @Niki M Hiles,

Thank you for posting your question in the Microsoft Q&A forum.

For clearly understand the situation, can you please share some more details about your expected outcome so I can provide the most appropriate solution for your concern. I greatly appreciate your cooperation and understanding.

• When 2026 = 0, do you want 2027 to be 0, blank, keep the value already in 2027 cell or some other value?
• Is the rate always 3.26% or does it vary by year/percentage of the value in 2026 or something else?
• What is your expected sheet layout? (e.g. amount of 2026 in B2 = $25,891,151, in B3 calculate the amount of 2027, etc.)

Please understand that my initial response may not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution. 

Thank you for your understanding and cooperation. I look forward to hearing from you.

Answer 3

What if 2026 is 0, how do I keep 2027 as is. I need to add % to a dollar amount based on the year before. How do I do an if statement. Example: if 2026=$25,891,151 and i want to add 3.26% for 2027. Need to take in account if 2026 =0. If then statement?

Answer 4

To implement an IF statement in Excel for your scenario where you want to add a percentage to a dollar amount based on the previous year's value, you can use the following formula:

=IF(A1=0, 0, A1 * (1 + 3.26%))

In this formula:

• A1 represents the cell where the 2026 dollar amount (e.g., $25,891,151) is located.
• The IF function checks if the value in A1 is 0. If it is, the formula returns 0. If it is not, it calculates the new amount by multiplying the value in A1 by 1 plus the percentage increase (3.26%).

This way, if the 2026 amount is zero, the result for 2027 will also be zero; otherwise, it will reflect the increased amount based on the specified percentage.

---

References:

• How to use a logical AND or OR in a SUM+IF statement in Excel