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: from Adelaide Australia

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

The next step is to replace the (a2*0.16) bracket with...

(a2-0.5) - keep each formula in its own bracket pair. then add
((a2-0.5)*.4) - Excel will calculate the inner bracket 1st then add the last
part
finally the formula looks like this...(((A2-0.5)*.4)+0.3) with 3
calculations in one.
have fun..
Len