Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
maximum characters? | Excel Worksheet Functions | |||
Finding Maximum | Excel Worksheet Functions | |||
Maximum If Help | Excel Worksheet Functions | |||
MAXIMUM VALUE | Excel Worksheet Functions | |||
Specify Maximum Value | Excel Discussion (Misc queries) |