Forum Discussion
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 (column-A1), Value increases by 2% if (columnB1)>1, and decreases by 2% if <1 (column-B1). So column-C1 is 102 or 98 depending on column B1 value.
Cannot seem to figure out how to craft this one.
Thanks!
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.)
2 Replies
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.
