how to write if statement in excel for state

June 7, 2011 at 23:02:44
Specs: Windows Vista
trying to write a simple IF statement.
=if(B2>9:45,"Late","Good").
When doing this it keeps giving me #VALUE! result. When i change to read just>945 it work but i wont to know how i can stick with using times and not numbers.

If anyone can help i would greatly appreciate it.

Thanks


See More: how to write if statement in excel for state

Report •


#1
June 8, 2011 at 04:00:04

Report •
Related Solutions


Ask Question