I have just realised I need a second criteria in a calculation but cannot figure how to join them
this checks if the entered data is a delivery or a removal of goods![]()
=IF(A2="DELIVERY",(H1+G2),(H1-G2))
I also need it to take into account ONLY deduct from H1 if D2="MHY"
Any help appreciated![]()
=IF(D2="MHY",(H1-G2),(H1-0))
Bookmarks