Formula Result Won't Query

N

natei6

Hi All,

I have a range of cells and some of them contain this formula:
=IF($C$1="Glamour","15.688",IF($C$1="Econo","15.563","Select Style")).
The problem I have is when I query this range on another work sheet, it
leaves the results of any cells with this formula blank. It is
important to me to have this formula in the cell, do you have any
suggestions.

Sincerely,

Nathan Sargeant
 
B

Biff

Hi!

What's the other formula look like?
=IF($C$1="Glamour","15.688",IF($C$1="Econo","15.563","Select Style"))
Click to expand...

Try removing the quotes from around the numbers:

=IF($C$1="Glamour",15.688,IF($C$1="Econo",15.563,"Select Style"))

Biff
 
Top