Formula Problem - If Statement

[Guest]

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.

 

[Don Guillett]

modify this idea to suit. Start at the top and work your way down.
For text use double quote " text "

=IF(E14>3,"h",IF(E14>10,2,IF(E14>0,1,"")))

 

[N Harkawat]

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,FormulaTables!E25))

 

[Guest]

Thank you! Knew it had to have something to do with the "".

 

[Guest]

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!