Formula with If and others

B

Barb Reinhardt

=if((B1-A1)/A1>1.1,"UP",if((B1-A1)/A1<.9,"DOWN","???"))

You can then put a conditional format on the cell to change the color with
FORMAT -> CONDITIONAL FORMAT
Enter Cell Value is Equal to "UP" and "DOWN" and format as desired.
 
B

Barb Reinhardt

I'm having a brain fade tonight on formulas. I guess it's the foot that was
hit with a softball and it's already got quite the bump.

In the if, change the expression to

=IF(B1/A1>1.1,"UP",IF(B1/A1<0.9,"DOWN","???"))
 
E

Eli

For example, I have three columns as follows:

A B C
1 100 120
2 100 80

I'd like to set up a formula applying to the cells in column C. If B1 value
is higher than A1 by 10%, C1 will show a word "Up" in green. With this
formula C2 will have "Down" in red. Appreciate your help.
Thanks,
Eli
 
Top