ExcelBanter - IF function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF function (https://www.excelbanter.com/excel-discussion-misc-queries/168493-if-function.html)

Sunshine

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.

Dave Peterson

IF function

Maybe...

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

Sunshine wrote:

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.

--

Dave Peterson

All times are GMT +1. The time now is 07:05 PM.