excel

Occasional Contributor

Hi Everybody

         Can Anyone tell me VAT remove formulas .

VAT add formula is A1 (price) x A2(20%) = VAT

If i do opposite A1 (price)  / A2(20%) = gives me wrong figure

3 Replies

@DEOL48 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

@DEOL48 

Perhaps

=A1/(1+A2)

if in A1 is the price with VAT

Thanks Sergei