Formula Problem

[Colin Weir]

Hi

I'm struggling with a formula in an excel sheet I'm working on.

I recently created a time sheet for the people in my work. One person
however get public holidays a different method from everyone else -
she only gets half a working day.

My initial formula that works fine is
=IF(OR(B12="A/L",B12="S/L",B12="P/H"),7/24,IF(B12="FLEXI",0,C12-B12-
D12))

My ammended ones is
=IF(OR(B12="A/L",B12="S/L"),7/24,IF(B12="P/H",3.5/24),IF(B12="FLEXI",
0,C12-B12-D12))

However it doesn't want to work for me.

Can anyone give me any suggestions?

Thanks

Colin

 

[Bernard Liengme]

Looks like a syntax error.
=IF(OR(B12="A/L",B12="S/L"),7/24, IF(B12="P/H",3.5/24 ,IF(B12="FLEXI",
0,C12-B12-D12)))

=IF(test1, test1_true, IF(test2, test2_true, IF(test3, test3_true,
test3_false) ) )

best wishes

 

[Roger Govier]

Hi Colin

I think you have a parenthesis in the wrong place
Try
=IF(OR(B12="A/L",B12="S/L"),7/24,IF(B12="P/H",3.5/24,
IF(B12="FLEXI",0,C12-B12-D12)))


--
Regards
Roger Govier

Hi

I'm struggling with a formula in an excel sheet I'm working on.

I recently created a time sheet for the people in my work. One person
however get public holidays a different method from everyone else -
she only gets half a working day.

My initial formula that works fine is
=IF(OR(B12="A/L",B12="S/L",B12="P/H"),7/24,IF(B12="FLEXI",0,C12-B12-
D12))

My ammended ones is
=IF(OR(B12="A/L",B12="S/L"),7/24,IF(B12="P/H",3.5/24),IF(B12="FLEXI",
0,C12-B12-D12))

However it doesn't want to work for me.

Can anyone give me any suggestions?

Thanks

Colin


__________ Information from ESET Smart Security, version of virus
signature database 4760 (20100111) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4760 (20100111) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Colin Weir]

Working great now.

Thanks

Colin