ExcelBanter - IF Statment

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

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

- - IF Statment (https://www.excelbanter.com/excel-discussion-misc-queries/212721-if-statment.html)

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

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

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.

"Momo" wrote in message
...
Can someone let me know why this formula is not working?

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

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

http://groups.google.com/group/micro...e88501f97f2fe#

Pete

On Dec 6, 6:56*pm, Momo wrote:
Can someone let me know why this formula is not working?

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