If then statement

Question

If then statement

Niki M Hiles 0

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.What if 2026 is 0, how do I keep 2027 as is. If then statement?

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Clover-L 5 Reputation points Microsoft External Staff Moderator

2026-02-25T18:34:49.8133333+00:00

This thread is duplicated with this thread : https://learn.microsoft.com/en-us/answers/questions/5788803/if-statement

1 answer

Clover-L 5 Reputation points Microsoft External Staff Moderator

2026-02-25T18:34:49.8133333+00:00

This thread is duplicated with this thread : https://learn.microsoft.com/en-us/answers/questions/5788803/if-statement

Answer 1

To create an IF statement in Excel that adds a percentage to a dollar amount based on the previous year's value, you can use the following formula:

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

In this formula:

A1 represents the dollar amount for the year 2026 (e.g., $25,891,151).
B1 represents the dollar amount for 2027, which you want to keep unchanged if 2026 is 0.
If the value in A1 is 0, the formula returns the value in B1. Otherwise, it calculates the new amount by adding 3.26% to the value in A1.

This way, if 2026's amount is 0, 2027's amount remains the same; otherwise, it increases by 3.26%.

Share via

If then statement

1 answer