You're welcome. Thanks for the feedback!

Biff

"natei6" wrote in
message ...

Biff Wrote:
Hi!

What's the other formula look like?

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

Try removing the quotes from around the numbers:

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

Biff

"natei6" wrote
in
message ...

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.56 3","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


--
natei6

------------------------------------------------------------------------
natei6's Profile:
http://www.excelforum.com/member.php...fo&userid=7185
View this thread:
http://www.excelforum.com/showthread...hreadid=487745

Thank you so much for the quick response Biff. You are the Man!
Nathan Sargeant


--
natei6
------------------------------------------------------------------------
natei6's Profile:
http://www.excelforum.com/member.php...fo&userid=7185
View this thread: http://www.excelforum.com/showthread...hreadid=487745