If Forumla
 

I'm so sorry I need help!!!!
I'm trying to do an "IF" formula but I'm not very knowledgeable with that
formula.
This is what I'm needing for example:

IF L57="A", 1.10, "B", 1.40, "C", 1.20

I hope that makes sense! No matter what I do it won't work. I'll try to
explain better if I need to.

If Forumla
 

Because you have more than 1 arguement in the formula you need to have more
than 1 if statement. It should read as follows

=IF L57="A", 1.10, if("B", 1.40, if("C", 1.20,0)))

"huntress731" wrote:

I'm so sorry I need help!!!!
I'm trying to do an "IF" formula but I'm not very knowledgeable with that
formula.
This is what I'm needing for example:

IF L57="A", 1.10, "B", 1.40, "C", 1.20

I hope that makes sense! No matter what I do it won't work. I'll try to
explain better if I need to.

If Forumla
 

Thank you for your suggestion and I tried it and for some reason I keep
getting an error? I typed exactly what you wrote. I'm so sorry for being so
dumb in the formula.

"Hawksby" wrote:

Because you have more than 1 arguement in the formula you need to have more
than 1 if statement. It should read as follows

=IF L57="A", 1.10, if("B", 1.40, if("C", 1.20,0)))

"huntress731" wrote:

I'm so sorry I need help!!!!
I'm trying to do an "IF" formula but I'm not very knowledgeable with that
formula.
This is what I'm needing for example:

IF L57="A", 1.10, "B", 1.40, "C", 1.20

I hope that makes sense! No matter what I do it won't work. I'll try to
explain better if I need to.

If Forumla
 

Huntress

A few typos in previous suggested formula. Try this revision.

=IF(L57="A", 1.1, IF(L57="B", 1.4, 1.2))

No need for the third IF. If not A or B then has to be something other so 1.20
gets returned.


Gord Dibben MS Excel MVP


On Thu, 14 Dec 2006 11:13:00 -0800, huntress731
wrote:

Thank you for your suggestion and I tried it and for some reason I keep
getting an error? I typed exactly what you wrote. I'm so sorry for being so
dumb in the formula.

"Hawksby" wrote:

Because you have more than 1 arguement in the formula you need to have more
than 1 if statement. It should read as follows

=IF L57="A", 1.10, if("B", 1.40, if("C", 1.20,0)))

"huntress731" wrote:

I'm so sorry I need help!!!!
I'm trying to do an "IF" formula but I'm not very knowledgeable with that
formula.
This is what I'm needing for example:

IF L57="A", 1.10, "B", 1.40, "C", 1.20

I hope that makes sense! No matter what I do it won't work. I'll try to
explain better if I need to.