Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
string forumla - before the and, after the and | Excel Discussion (Misc queries) | |||
IF Forumla help | Excel Discussion (Misc queries) | |||
HELP!!! Can't get forumla figured out! | Excel Discussion (Misc queries) | |||
Which Forumla and How do I configure in Excel? | Excel Discussion (Misc queries) | |||
test forumla rather than result | Excel Worksheet Functions |