Hi Len

Thanks for your help!

Also what I now need to do is to include another formula:

IF A1="INTERNATIONAL" I need to firstly deduct 0.50 from A2, then multiply
this amount by 40% then add 0.30

Please can you help me again?

Thanks again and regards from Mallorca
Amanda




"len" wrote:

ans=
=IF(A1="international",(A2*0.16),IF(A1="European", (A2*0.2),(A2*0.1)))

"Amanda" wrote:


I want to say IF A1 = "International" then multiply A2 by 16% and if A1 =
"European" then multiply A2 by 20% and if A1 = National then multiply A2 by
10% etc etc etc
Please can anybody help?