Excel Formulas

Copper Contributor

How do I in Excel create this formula?

100+20%(VAT)+30%(wastage)

3 Replies

@Bespoke_F 

That's practically as you wrote

 

=100+A1*20% +B1*30%

if VAT in A1 and wastage in B1

 

Thank you @Sergei Baklan 

@Bespoke_F , you are welcome