Thread: Maximum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louisq Louisq is offline
external usenet poster
 
Posts: 6
Default Maximum

Dear Colleagues,
I have a row in a spreadsheet with three cells that I want to find the max.
Each cell is a references an IF statement. The cells contain time:
mmss-format. When I use the max. function it will not work-on this row. On
other rows it works.
I tried using Clear All to clear the rows and building the IF statements
again and had the same result.

In the next cell, I tried an average formula and it worked. Even using other
time formats did not prove successful with the max formula. And the minimim
will not work too. Any suggestions would be greatly appreciated. Thanks.

Louis