if then formulas

  • Thread starter Thread starter Karyn
  • Start date Start date
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.
 
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...
 
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
 
Back
Top