ExcelBanter - IF Formula

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - IF Formula (https://www.excelbanter.com/new-users-excel/190452-if-formula.html)

myr

IF Formula

Can I use IF formula to ccmpare time? Ex =IF (A4=24:00:00, "24")

T. Valko

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

All times are GMT +1. The time now is 06:55 AM.