View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eli[_2_] Eli[_2_] is offline
external usenet poster
 
Posts: 2
Default Formula with If and others

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