Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Result Won't Query
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Result Won't Query
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Result Won't Query
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
excel | Excel Worksheet Functions | |||
Formula shown as a formula rather than it's result | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions |