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.

=IF(A1="US",B1*(1+C1),IF(A1="India",B1*(1+D1),"wha tever you want as the
answer if A1 is neither US nor India"))
--
David Biddulph

"Karyn" wrote in message
...
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...

--
Kind regards

Rik


"Karyn" wrote:

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.

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



"Karyn" wrote:

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.

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

"Karyn" wrote:

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.