Tax% som-if formule

Hi Guyes

I need some help with mijn accounting in excell..

i'm tyring to:

Cell A1 is an ammount like 100 euro's
Cell A2 is tax % like 9 or 21%
Cell A3 should be the ammount of tax

So is A2 is 9% formule should do A1/109*9
or if A2 is 21% formule should do A1/121*21

I'm no expert, and can't figure out whats it should be..

Can anyone help me ?

Thanks in advance

Regards,
Mark

Hoi

bedankt voor je reactie..

Ik zoek alleen dat de formule ook eerst kijkt wat het percentage in A2 is en daarna de juiste berekening toepast.

Groet,
Mark

If A1=100, A2=9%, A3=A1*A2/(1+A2)