| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement
I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS
Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
Try this:
=IF(OR(F66=0,F662),0,IF(F66=1,Q73,Q74)) If F66 is blank or does contain a number 1 or 2 you will get a 0 Hope this helps "Smitty2" wrote: I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
--Check your formulas in Q73 and Q74 and try...
--Check out whether F66 contains the numeric 1/2 or is rounded off to display 1/2 =IF(F66=1,Q73,IF(F66=2,Q74,"")) -- Jacob "Smitty2" wrote: I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
Thanks, but this did not work. If L73 was 248000, the answer should be 2400
but it still comes back 0. Do you see anything else that might work? "Ron@Buy" wrote: Try this: =IF(OR(F66=0,F662),0,IF(F66=1,Q73,Q74)) If F66 is blank or does contain a number 1 or 2 you will get a 0 Hope this helps "Smitty2" wrote: I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
Thanks, but this did not work. I forgot to tell you that I use Excel 2003.
If L73 was 248000, the answer should be 2400 but it still comes back 0. This answer sounds very logical and I have tried it before but again, I get 0 for the answer. I did check to see if it was rounding and it is not, it is just the numeric. I just can't seem to get it to work the equation. Do you see anything else that might work? "Jacob Skaria" wrote: --Check your formulas in Q73 and Q74 and try... --Check out whether F66 contains the numeric 1/2 or is rounded off to display 1/2 =IF(F66=1,Q73,IF(F66=2,Q74,"")) -- Jacob "Smitty2" wrote: I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
Modify your formulas to
=LOOKUP(VALUE(L73),{0,200000,240000,270000,300000} , {0,2000,2400,2700,3000}) =LOOKUP(VALUE(L74),{0,100000,140000,170000,200000} , {0,2100,2400,2700,3000}) 'and then apply =IF(F66=1,Q73,IF(F66=2,Q74,"")) -- Jacob "Smitty2" wrote: Thanks, but this did not work. I forgot to tell you that I use Excel 2003. If L73 was 248000, the answer should be 2400 but it still comes back 0. This answer sounds very logical and I have tried it before but again, I get 0 for the answer. I did check to see if it was rounding and it is not, it is just the numeric. I just can't seem to get it to work the equation. Do you see anything else that might work? "Jacob Skaria" wrote: --Check your formulas in Q73 and Q74 and try... --Check out whether F66 contains the numeric 1/2 or is rounded off to display 1/2 =IF(F66=1,Q73,IF(F66=2,Q74,"")) -- Jacob "Smitty2" wrote: I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
You were writing text strings, not numbers. Get rid of the double quotes if
you want numbers. -- David Biddulph "Smitty2" wrote in message ... Thanks, but this did not work. If L73 was 248000, the answer should be 2400 but it still comes back 0. Do you see anything else that might work? "Ron@Buy" wrote: Try this: =IF(OR(F66=0,F662),0,IF(F66=1,Q73,Q74)) If F66 is blank or does contain a number 1 or 2 you will get a 0 Hope this helps "Smitty2" wrote: I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| If statement or lookup statement not sure | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Linear Mode
