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