Hi all,
I am using Excel 2013.
I have the following formula in cell N3
How can I expand it so that if M3 contains “Weekend” and L3<=5 I would like the cell to be populated with 300 otherwise populate it with L3*B3*24
I have tried
and I get #VALUE! displayed in N3
Your assistance will be appreciated.
I am using Excel 2013.
I have the following formula in cell N3
Rich (BB code):
=IF(AND(M3="Weekday",L3<=5),200,L3*B3*24)
How can I expand it so that if M3 contains “Weekend” and L3<=5 I would like the cell to be populated with 300 otherwise populate it with L3*B3*24
I have tried
Rich (BB code):
=IF(AND(M3="Weekday",L3<=5),200,L3*B3*24),IF(AND(M3="Weekend",L3<=5),300,L3*B3*24)
Your assistance will be appreciated.