IF Statment

[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)

 

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

 

[Pete_UK]

Did you not like the answers to your earlier post? You can find it
here:

http://groups.google.com/group/micr...functions/browse_frm/thread/922e88501f97f2fe#

Pete