| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF Formula
Can I use IF formula to ccmpare time? Ex =IF (A4=24:00:00, "24")
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
IF Formula
Assuming A4 is formatted as [h]:mm:ss
Try this: =IF(A4=1,24,"no") -- Biff Microsoft Excel MVP "myr" wrote in message ... Can I use IF formula to ccmpare time? Ex =IF (A4=24:00:00, "24") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
