if then formulas

K

Karyn

I'm trying to write a formala that does this:

If A="US", then B*(1+C), If A = "India", then B*(1+D)

Any suggestions would be greatly appreciated.
 
D

David Biddulph

=IF(A1="US",B1*(1+C1),IF(A1="India",B1*(1+D1),"whatever you want as the
answer if A1 is neither US nor India"))
 
R

Rik_UK

Your almost there...

assuming data is in row 1 then, the formula can then be copied down the
table...

=IF(A1="US",B1*(1+C1),B1*(1+D1))

This is fine if the data in column a is only ever US or India, however to be
more discrete it may be necessary to use

=IF(A1="US",B1*(1+C1),IF(A1="India",B1*(1+D1),""))

Hope this helps...
 
M

Mike H

Karyn,

I can't follow this logic very well so here's a guess

=IF(A1="US",B1*(1+C1),IF(A1="India",B1*(1+D1),""))

Mike
 
Top