Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Problem - If Statement
I am trying to create a formula that if the value entered in cell b40 is
greater than or equal to $75,000,000., the result in cell B68 should read "REFER TO COMPANY". The formula looks like this: =IF(B40=75000000,'REFER TO COMPANY',IF(B40<=24000000,'Formula Tables'!B25,'Formula Tables'!E25)) The two formula tables referenced in the formula are for values <=24,000,000 and values =24,000,001. I need a third option that returns text that reads "refer to company" if B40 is =75,000,000. I am erroring out, however. If I put "" around 'refer to company', the cell returns #name?; if I leave it as shown, I get a message stating there is "an error in the formula, consult Excel help". I'd rather go to the experts....could someone tell me where I've gone wrong? Thanks very much. |
#3
|
|||
|
|||
This works for me
=IF(B40=75000000,"REFER TO COMPANY",IF(B40<=24000000,'Formula Tables'!B25,'Formula Tables'!E25)) assuming that the sheet name is "formula tables" )(note the space between the 2 words) if there isn't any space, then the sheet name that is currently enclosed within commas will simply change as follows: =IF(B40=75000000,"REFER TO COMPANY",IF(B40<=24000000,FormulaTables!B25,Formul aTables!E25)) "Margie" wrote in message ... I am trying to create a formula that if the value entered in cell b40 is greater than or equal to $75,000,000., the result in cell B68 should read "REFER TO COMPANY". The formula looks like this: =IF(B40=75000000,'REFER TO COMPANY',IF(B40<=24000000,'Formula Tables'!B25,'Formula Tables'!E25)) The two formula tables referenced in the formula are for values <=24,000,000 and values =24,000,001. I need a third option that returns text that reads "refer to company" if B40 is =75,000,000. I am erroring out, however. If I put "" around 'refer to company', the cell returns #name?; if I leave it as shown, I get a message stating there is "an error in the formula, consult Excel help". I'd rather go to the experts....could someone tell me where I've gone wrong? Thanks very much. |
#4
|
|||
|
|||
Thank you! Knew it had to have something to do with the "".
"N Harkawat" wrote: This works for me =IF(B40=75000000,"REFER TO COMPANY",IF(B40<=24000000,'Formula Tables'!B25,'Formula Tables'!E25)) assuming that the sheet name is "formula tables" )(note the space between the 2 words) if there isn't any space, then the sheet name that is currently enclosed within commas will simply change as follows: =IF(B40=75000000,"REFER TO COMPANY",IF(B40<=24000000,FormulaTables!B25,Formul aTables!E25)) "Margie" wrote in message ... I am trying to create a formula that if the value entered in cell b40 is greater than or equal to $75,000,000., the result in cell B68 should read "REFER TO COMPANY". The formula looks like this: =IF(B40=75000000,'REFER TO COMPANY',IF(B40<=24000000,'Formula Tables'!B25,'Formula Tables'!E25)) The two formula tables referenced in the formula are for values <=24,000,000 and values =24,000,001. I need a third option that returns text that reads "refer to company" if B40 is =75,000,000. I am erroring out, however. If I put "" around 'refer to company', the cell returns #name?; if I leave it as shown, I get a message stating there is "an error in the formula, consult Excel help". I'd rather go to the experts....could someone tell me where I've gone wrong? Thanks very much. |
#5
|
|||
|
|||
Thanks Don. I'm going to keep this one taped to my monitor - can use it for a
variety of other formulas as well. Have a good weekend! "Don Guillett" wrote: modify this idea to suit. Start at the top and work your way down. For text use double quote " text " =IF(E143,"h",IF(E1410,2,IF(E140,1,""))) -- Don Guillett SalesAid Software "Margie" wrote in message ... I am trying to create a formula that if the value entered in cell b40 is greater than or equal to $75,000,000., the result in cell B68 should read "REFER TO COMPANY". The formula looks like this: =IF(B40=75000000,'REFER TO COMPANY',IF(B40<=24000000,'Formula Tables'!B25,'Formula Tables'!E25)) The two formula tables referenced in the formula are for values <=24,000,000 and values =24,000,001. I need a third option that returns text that reads "refer to company" if B40 is =75,000,000. I am erroring out, however. If I put "" around 'refer to company', the cell returns #name?; if I leave it as shown, I get a message stating there is "an error in the formula, consult Excel help". I'd rather go to the experts....could someone tell me where I've gone wrong? Thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Precision problem with automated formula fill-in | Excel Worksheet Functions | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
IF statement problem | Excel Worksheet Functions | |||
Formula Problem | Excel Discussion (Misc queries) |