Thread: compare the value cell then use one formula if <= or another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BThrasher
 
Posts: n/a
Default compare the value cell then use one formula if <= or another
I need to compare the value in a cell4. If cell4 <= 160 then cell2 =
160-cell4, or if cell4 is 160 then cell2 = 80, Cell3 will = cell4-cell2

I hope this is understandable.
Reply With QuoteReply With Quote