how do i use if function to different texts

A

Amanda

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?
 
M

Marcelo

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:
 
A

Amanda

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
 
A

Amanda

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
 
M

Marcelo

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:
 
L

len

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
Click to expand...

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
 
Top