ok

first the 2 brackets at the end are to close all the formula the first one
close the second if and the last one close the first if.

an if formula works at if(conditional,actions if the condion is true, action
if the conditional is false)

=IF(A1="international",(((A2-0,50)*,4)+,30)*16%,IF(A1="european",A2*20%,0))

HTH
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Amanda" escreveu:


Hi Marcelo

Thanks very much, Please can you explain the reason for having 2 closing
brackets at the end? Is this for the number of arguments?

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


"Marcelo" wrote:

hi Amanda,

try

=IF(A1="international",A2*16%,IF(A1="european",A2* 20%,0))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Amanda" escreveu:


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?