help with multiple condition formula

[pembr0ke]

excel example.jpg


hopefully my image file has uploaded and you can see the spreadsheet I'm working on. I'm stuck calculating a formula based on the contents of two separate cells.The formula in g36 is:

IF $C$12=1,(C25*D25)*.2,F25*.2),”0.00”

this formula calculates the VAT either on cost price or mark-up price. What I need is for the formula to also consider the contents of cell c10 which displays either ‘YES’ or ‘NO’ indicating if a customer is VAT exempt.

If the customer is VAT exempt I would like my spreadsheet to display “£0.00” in g36 instead of performing any of the previous calculations.

all help is very, very much appreciated!

thank you!!

[Special-K]

Unbalanced parenthesis in the formula, I presume this is a typo (Excel wouldn't let you enter that the way it is)

in G36
=IF(C10="NO",0,IF(C12=1,C25*D25,F25)*0.2)