IF function

  • Thread starter Thread starter Sunshine
  • Start date Start date
S

Sunshine

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.
 
Maybe...

=if(f5="11a-7p",7.5,if(f5="6a-1:30p",7,if(f5="6:30a-1:30p",6.5,"Unknown")))
 
Back
Top