Forum Discussion
Solved
Value, AND/OR Function for Excel
How can I make a function in Excel, so that I could get a value from X-column to increase or decrease in value by X%, and it is effected by another value of column-Y. E.g. Initial value is 100 (c...
In C1:
=A1*IF(B1>1,102%,98%)
(You didn't mention what should happen if B2 = 1. In the above formula, it will subtract 2%. If you want to add 2%, change > to >= in the formula.)
In C1:
=A1*IF(B1>1,102%,98%)
(You didn't mention what should happen if B2 = 1. In the above formula, it will subtract 2%. If you want to add 2%, change > to >= in the formula.)
Thank you, this helped! I needed to use ; instead of , to make it work.
