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