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 keep getting the INVALID error. I'm trying to use the IF function for a
work schedule:

If F5=11a-7p, then "7.5",(f5=6a-1:30p, then "7",(F5=6:30a-1:30p,then"6.5".

I'm thinking its because 11a-7p is not a value. Is there another function I
can use the shifts.