Thread: "IF" syntax
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 244
Default "IF" syntax

I need some help using "IF" syntax in Excel "97."
I want to compare the value(values are minutes&seconds) in
one cell with another cell
and depending on which cell has the greater value I would
like value displayed in a cell.
Example:

Cell D7 Cell E7
33:15 32:05

Cell C7 should display the greater of the two values.
I would also like Cell C7 to add 20 seconds to the
inserted value. I just can't figure this out; here is the
formula I created
=IF(D7<E7,D7,E7)+20
But it doesn't work.

Chris