View Single Post
  #3   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

Also...

=LOOKUP(A2-B2,{-9.99999999999999E+307,0,2.229E-308},{"Decrease","Same","Increase"})

Michael wrote:
Hi Folks - I have the follwoing data:

Col A Col B Col C
45 50 Increase
60 75 Increase
65 50 Decrease
44 44 Same

Is there a function I can use in Col C to determine if a cell value
increased, decreased or stayed the same? Thanks in advance.

Michael