"IF" syntax in Excel "97"

[Chris]

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

 

[Frank Kabel]

Hi
try
=IF(D7<E7,D7,E7)+TIME(0,0,20)

 

[Paul Corrado]

=MAX(D7:E7)+(20/(60*24))

The 20/(60*24) converts 20 seconds to a part of a day, which has a value of
1 in Excel

 

[Guest]

Neither one of these work. Thanks for the help.

Chris

 

[Frank Kabel]

Hi
what result do you get and what is exactly not working

 

[Bernie Deitrick]

Chris,

Frank had the sign wrong:

=IF(D7<E7,D7,E7)+TIME(0,0,20)

should be

=IF(D7>E7,D7,E7)+TIME(0,0,20)

Note that if you actually entered mm:ss values (enter the times as 0:33:15,
NOT 33:15), then that should work. Otherwise, you may be actually enter
hh:mm times, in which case what you think are minutes are actually hours,
and your formula would need to be

=IF(D7>E7,D7,E7)+TIME(0,20,0)

HTH,
Bernie
MS Excel MVP

 

[Chris]

I'm not getting anything, the only thing that displayes in
the cell is the formula.
I've tried using 33:12 and 00:33:12
Yes, I did not use the > in the formula.

Chris

 

[Frank Kabel]

Hi
check if the cell is formated to 'Time' and re-enter the formula

 

[Guest]

That's it! I can't believe I did something that stupid!
I stored the values as "text" and not "Time"
Thanks!!!
Chris