Best formula to use??

[emmatm]

Hi hope youcan help?!

I have the following information:
* A data validation list in F9 cell and the options are either vatable or non vatable
* A cell that states the selling price to a customer before VAT in E9
* A cell that states the buying price gross K9
* A cell for the margin in L9

I a trying to return a sum in cell L9 which if cell F9 is vatable will take the value from E9 and remove the 20% VAT then deduct K9 from E9 giving the margin, however should the cell F9 be non vatable then the result sould just be K9 minus E9.

Is this possible??

 

[Somendra Misra]

Hi emmatm,

Welcome to the forum.

In the absence of sample please try below formula in L9

=IF(F9="Vatable",(E9*0.8)-K9,K9-E9)

Just abvise if any issue.

Regards,

 

[Luke M]

Welcome to the forum!
I believe, based on what's in the cells, that formula should be
=SellingPrice(adjusted for VAT) - BoughtPrice,
=E9*IF(F9="vatable",0.8,1)-K9