Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
I have the following formula in a cell
=IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
So what result is the formula giving?
-- Biff Microsoft Excel MVP "Oldjay" wrote in message ... I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
Please clarify: "When I look at the function arguments it says both
ID606='Y' and ID606="N" are true" best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Oldjay" wrote in message ... I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
You don't tell us what is actually happening that you think is not right nor
have you told us what you think should have happened, so it is kind of hard to answer your question. However, based on how your formula is set up, this part of the formula will execute if ID606=""... IF($C$256$C$250,$C$255,$C$249) So either the contents of C255 or C249 will be displayed depending on the relationship between C256 and C250. -- Rick (MVP - Excel) "Oldjay" wrote in message ... I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
Hi,
Whats' going on? It's a nested if statement that says =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250,$C$255,$C$249))) IF ID606 = Y then return the contents of C254 If that evaluates as TRUE then that's the end of the matter but if ID606 isn't Y it carries on IF ID606 = N then return C248 Once again if that's true then the formula stops but if ID606 is neuther Y or N then it carries on and asks If C256 is greater than C250 return C255 and if that's not true return the contents of C249. Mike "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
hi
no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
You are correct. The cell returns the value in C254
"FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
The cell returns the value in C254
If that's the result of the formula then ID606 does =Y. If you say ID606 is blank then there might be conditional formatting suppressing the display of the Y. Try this formula in some empty cell: =ID606="" What result do you get? -- Biff Microsoft Excel MVP "Oldjay" wrote in message ... You are correct. The cell returns the value in C254 "FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
Just to add to Biff's suggestion...
It could be caused by other formatting, too. I'd try clearing the formats. In xl2003 menus: Select the cell edit|clear|formats "T. Valko" wrote: The cell returns the value in C254 If that's the result of the formula then ID606 does =Y. If you say ID606 is blank then there might be conditional formatting suppressing the display of the Y. Try this formula in some empty cell: =ID606="" What result do you get? -- Biff Microsoft Excel MVP "Oldjay" wrote in message ... You are correct. The cell returns the value in C254 "FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
I had already reformated the cell to General. That didn't help.
In answer to Biff's request. it returns a 0 "Dave Peterson" wrote: Just to add to Biff's suggestion... It could be caused by other formatting, too. I'd try clearing the formats. In xl2003 menus: Select the cell edit|clear|formats "T. Valko" wrote: The cell returns the value in C254 If that's the result of the formula then ID606 does =Y. If you say ID606 is blank then there might be conditional formatting suppressing the display of the Y. Try this formula in some empty cell: =ID606="" What result do you get? -- Biff Microsoft Excel MVP "Oldjay" wrote in message ... You are correct. The cell returns the value in C254 "FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
You have a lotus 123 transition setting checked.
In xl2003 menus: tools|Options|transition tab Uncheck all those settings. Oldjay wrote: I had already reformated the cell to General. That didn't help. In answer to Biff's request. it returns a 0 "Dave Peterson" wrote: Just to add to Biff's suggestion... It could be caused by other formatting, too. I'd try clearing the formats. In xl2003 menus: Select the cell edit|clear|formats "T. Valko" wrote: The cell returns the value in C254 If that's the result of the formula then ID606 does =Y. If you say ID606 is blank then there might be conditional formatting suppressing the display of the Y. Try this formula in some empty cell: =ID606="" What result do you get? -- Biff Microsoft Excel MVP "Oldjay" wrote in message ... You are correct. The cell returns the value in C254 "FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay -- Dave Peterson -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
Thanks - That did the trick. "Transition formula evaluation" was checked
A couple of questions. I installed XL2003 on this computer as soon as I bought it 18 months ago. I have written cell formulas with up to 5 If statements many times in the past without this error showing up. Why now? While waiting for your answer I flip flopped the first two IF statements just to see what happened. This cleared up the error also. Why? "Dave Peterson" wrote: You have a lotus 123 transition setting checked. In xl2003 menus: tools|Options|transition tab Uncheck all those settings. Oldjay wrote: I had already reformated the cell to General. That didn't help. In answer to Biff's request. it returns a 0 "Dave Peterson" wrote: Just to add to Biff's suggestion... It could be caused by other formatting, too. I'd try clearing the formats. In xl2003 menus: Select the cell edit|clear|formats "T. Valko" wrote: The cell returns the value in C254 If that's the result of the formula then ID606 does =Y. If you say ID606 is blank then there might be conditional formatting suppressing the display of the Y. Try this formula in some empty cell: =ID606="" What result do you get? -- Biff Microsoft Excel MVP "Oldjay" wrote in message ... You are correct. The cell returns the value in C254 "FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay -- Dave Peterson -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
I'm not sure how this setting can get changed without manual intervention. But
stranger things have happened... Excel and Lotus treat empty cells differently. I have no idea why Lotus does it this way. All I know is that I turn all those transition settings off when I see them on -- they can make debugging a worksheet very difficult. Oldjay wrote: Thanks - That did the trick. "Transition formula evaluation" was checked A couple of questions. I installed XL2003 on this computer as soon as I bought it 18 months ago. I have written cell formulas with up to 5 If statements many times in the past without this error showing up. Why now? While waiting for your answer I flip flopped the first two IF statements just to see what happened. This cleared up the error also. Why? "Dave Peterson" wrote: You have a lotus 123 transition setting checked. In xl2003 menus: tools|Options|transition tab Uncheck all those settings. Oldjay wrote: I had already reformated the cell to General. That didn't help. In answer to Biff's request. it returns a 0 "Dave Peterson" wrote: Just to add to Biff's suggestion... It could be caused by other formatting, too. I'd try clearing the formats. In xl2003 menus: Select the cell edit|clear|formats "T. Valko" wrote: The cell returns the value in C254 If that's the result of the formula then ID606 does =Y. If you say ID606 is blank then there might be conditional formatting suppressing the display of the Y. Try this formula in some empty cell: =ID606="" What result do you get? -- Biff Microsoft Excel MVP "Oldjay" wrote in message ... You are correct. The cell returns the value in C254 "FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
I give up
Thanks so much!~! you guys do such a great job
"Dave Peterson" wrote: I'm not sure how this setting can get changed without manual intervention. But stranger things have happened... Excel and Lotus treat empty cells differently. I have no idea why Lotus does it this way. All I know is that I turn all those transition settings off when I see them on -- they can make debugging a worksheet very difficult. Oldjay wrote: Thanks - That did the trick. "Transition formula evaluation" was checked A couple of questions. I installed XL2003 on this computer as soon as I bought it 18 months ago. I have written cell formulas with up to 5 If statements many times in the past without this error showing up. Why now? While waiting for your answer I flip flopped the first two IF statements just to see what happened. This cleared up the error also. Why? "Dave Peterson" wrote: You have a lotus 123 transition setting checked. In xl2003 menus: tools|Options|transition tab Uncheck all those settings. Oldjay wrote: I had already reformated the cell to General. That didn't help. In answer to Biff's request. it returns a 0 "Dave Peterson" wrote: Just to add to Biff's suggestion... It could be caused by other formatting, too. I'd try clearing the formats. In xl2003 menus: Select the cell edit|clear|formats "T. Valko" wrote: The cell returns the value in C254 If that's the result of the formula then ID606 does =Y. If you say ID606 is blank then there might be conditional formatting suppressing the display of the Y. Try this formula in some empty cell: =ID606="" What result do you get? -- Biff Microsoft Excel MVP "Oldjay" wrote in message ... You are correct. The cell returns the value in C254 "FSt1" wrote: hi no it doesn't. the formula reads like this....... if id606 = "y" then return C254's value and stop there. however if ID606 does not ="Y" but = "N" then return C248's value and stop there. however if ID606 does not contain "Y" or "N" then look at C256 and check to see if it's greater than C250 and if it is, return c255's value but it its not then return c249's value. simple. or did i misunderstand you question. regards FSt1 "Oldjay" wrote: I have the following formula in a cell =IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250, $C$255,$C$249))) Cell ID606 is blank When I look at the function arguments it says both ID606='Y' and ID606="N" are true. What going on? oldjay -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up a value in one column and give a corresponding value | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
I would like to give a key an other task, is it possible? THANKS | Excel Discussion (Misc queries) | |||
How do I give a name to my group? | Excel Worksheet Functions | |||
please give me an example of vlookup | Excel Worksheet Functions |