Formula Result Won't Query

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

Hi!

What's the other formula look like?

> =IF($C$1="Glamour","15.688",IF($C$1="Econo","15.563","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" <natei6.1yysjy_1132774201.5328@excelforum-nospam.com> wrote in
message news:natei6.1yysjy_1132774201.5328@excelforum-nospam.com...
>
> 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
>
>
> --
> natei6
> ------------------------------------------------------------------------
> natei6's Profile:
> http://www.excelforum.com/member.php...fo&userid=7185
> View this thread: http://www.excelforum.com/showthread...hreadid=487745
>

Originally Posted by Biff

Hi!

What's the other formula look like?

> =IF($C$1="Glamour","15.688",IF($C$1="Econo","15.563","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" <natei6.1yysjy_1132774201.5328@excelforum-nospam.com> wrote in
message news:natei6.1yysjy_1132774201.5328@excelforum-nospam.com...
>
> 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
>
>
> --
> 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

You're welcome. Thanks for the feedback!

Biff

"natei6" <natei6.1yz21n_1132786501.4045@excelforum-nospam.com> wrote in
message news:natei6.1yz21n_1132786501.4045@excelforum-nospam.com...
>
> Biff Wrote:
>> Hi!
>>
>> What's the other formula look like?
>>
>> > =IF($C$1="Glamour","15.688",IF($C$1="Econo","15.563","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" <natei6.1yysjy_1132774201.5328@excelforum-nospam.com> wrote
>> in
>> message news:natei6.1yysjy_1132774201.5328@excelforum-nospam.com...
>> >
>> > 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
>> >
>> >
>> > --
>> > 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
>