Thread: IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sunshine Sunshine is offline
external usenet poster
 
Posts: 18
Default IF function

I'm trying to use the If function for a schedule.

If cell F5 = 11a-7p, then 7.5, if F5=6a-1:30p, then 7,If 6:30a-1:30p, then
6.5.

I keep getting the INVALID error.