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

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

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

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

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

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

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

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

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

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