IF Statment

M

Momo

Can someone let me know why this formula is not working?

=IF(AND(A3="Y",B3="DIRECTOR",D3<=12),D3*2,24),IF(AND(A3="Y",B3="MANAGER",D3<=12),D3*1.5,18),IF(AND(A3="Y",B3="WORKER",D3<=12),D3*1,12)
 
F

Fred Smith

It's not working because it's not a proper If statement. This portion:
=IF(AND(A3="Y",B3="DIRECTOR",D3<=12),D3*2,24)
is a complete statement. You can't just tack on stuff afterwards and expect
Excel to understand it.

If you need more help, tell us what what results you got that you didn't
like, and what you want to see instead.

Regards,
Fred.
 
Top