"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
|