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?
|
Similar Threads
