View Single Post
  #1   Report Post  
PK
 
Posts: n/a
Default comparing a value in a cell to see if it is higher than a number

Hi,

I need to compare a value in a cell and see if it is higher than 7.5. If it
is higher than 7.5 I want to subract 7.5 from it and move the result into
another cell. For instance. If B20 7.5 Subract 7.5 from B20 and Move to
B21. How can I do that easily? I was trying to use the IF function but
cannot find the correct formatting to get it to move the value to the B21
cell.

Thanks,

PK