Combine two IF statements in one cell

[nigelog]

I have just realised I need a second criteria in a calculation but cannot figure how to join them

Please Login or Register  to view this content.

this checks if the entered data is a delivery or a removal of goods

I also need it to take into account ONLY deduct from H1 if D2="MHY"

Please Login or Register  to view this content.

Any help appreciated

[meus]

Use nested If Statement..
Try this...
Hope it helps..

Please Login or Register  to view this content.

[meus]

Use nested If Statement..
Try this...
Hope it helps..

Please Login or Register  to view this content.

[nigelog]

Hi meus, had just figured it

[toblju]

You use the AND-function if I understand correct?
=IF(AND(A2="DELIVERY",D2="MHY"),(H1-G2),IF(A2="DELIVERY",(H1+G2),H2-G2))