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
=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