IF formula

[marcidee]

Please can someone help me expand this IF formula:

=if( E7 = "20% (VAT on Expenses)", K7 /1.2 , "")

I would like to expand this to:

IF E7 states 'No VAT' or 'Zero Rated Expenses' enter the value of K7 (answer will be placed in M7)

So the whole statement is:
IF E7 states:
No VAT or
Zero Rated Expenses - Insert the value of K7 (in M7)

If E7 has:
VAT on Expenses - K7/1.2 (in M7)

Thank you
Marc

 

[Joe4]

Try:

=if(E7="20% (VAT on Expenses)",K7/1.2,if(or(E7="No Vat",E7="Zero Rated Expenses"),K7,""))

 

[marcidee]

Brilliant - thank you

 

[Joe4]

You are welcome.