Nested IFs Not Calculating
 

I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there and
doesn't calculate the answer...it just shows the formula itself. Here is my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

The cell that your formula is in must be formatted as text. Change the
format to General and then enter the formula again (or hit F2 and then
enter). Your formula should then calculate the appropriate answer.

Hope that helps.

"Debbie" wrote:

I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there and
doesn't calculate the answer...it just shows the formula itself. Here is my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there
and
doesn't calculate the answer...it just shows the formula itself. Here is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Thank you so much for your quick response! I really appreciate it very much.

I had already formatted the column as text before creating the formula. I
did reformat to General as you suggested and then opened the cell with the
formula and hit Enter and it's still just sitting there.

Any other suggestions?

"William Horton" wrote:

The cell that your formula is in must be formatted as text. Change the
format to General and then enter the formula again (or hit F2 and then
enter). Your formula should then calculate the appropriate answer.

Hope that helps.

"Debbie" wrote:

I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there and
doesn't calculate the answer...it just shows the formula itself. Here is my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there. BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there
and
doesn't calculate the answer...it just shows the formula itself. Here is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

The problem is that the cell is formatted as a text field. It needs to be
formatted as GENERAL. Please change the format to General and then re-enter
the formula in the cell.

Any cell formatted as TEXT will just show whatever you type in it. It will
not calculate any formulas. That is why you must change the cell format to
General.

"Debbie" wrote:

Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there. BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there
and
doesn't calculate the answer...it just shows the formula itself. Here is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Try pressing Ctrl+~

"~" is the symbol above the Tab key.


"Debbie" wrote in message
...
Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there.
BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to be
a
simple nested IF statement, but when I leave the cell, it just sits
there
and
doesn't calculate the answer...it just shows the formula itself. Here
is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with
an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Thank you, William. I had it formulated as General and thought I had
reactivated the cell after doing so and got the same results. This time I
was careful to do exacly as you asked and it worked. That was a big DUH in
my book. I just wasn't thinking apparently.

Have a good day and thanks so much for your help!

"William Horton" wrote:

The problem is that the cell is formatted as a text field. It needs to be
formatted as GENERAL. Please change the format to General and then re-enter
the formula in the cell.

Any cell formatted as TEXT will just show whatever you type in it. It will
not calculate any formulas. That is why you must change the cell format to
General.

"Debbie" wrote:

Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there. BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there
and
doesn't calculate the answer...it just shows the formula itself. Here is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Perhaps that cell has been formatted as Text. Click on the cell and
Format | Cells | Number (tab) and select General | OK. Then double-
click in the cell as if to edit it and then click elsewhere (or press
Enter) to make the formatting change take effect.

Hope this helps.

Pete

On Apr 23, 6:36 pm, Debbie wrote:
I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there and
doesn't calculate the answer...it just shows the formula itself. Here is my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Thank you for responding. I did get the answer I was looking for, but I was
wondering what Ctrl+~ does...

Thanks!

"PCLIVE" wrote:

Try pressing Ctrl+~

"~" is the symbol above the Tab key.


"Debbie" wrote in message
...
Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there.
BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to be
a
simple nested IF statement, but when I leave the cell, it just sits
there
and
doesn't calculate the answer...it just shows the formula itself. Here
is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with
an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

This allows you to see all of your formula cells. Since you can't tell if a
cell contains a formula without clicking on them, it is difficult to find
those formula cells...especially if some of your formulas return blank
results.

Regards,
Paul

"Debbie" wrote in message
...
Thank you for responding. I did get the answer I was looking for, but I
was
wondering what Ctrl+~ does...

Thanks!

"PCLIVE" wrote:

Try pressing Ctrl+~

"~" is the symbol above the Tab key.


"Debbie" wrote in message
...
Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there.
BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to
be
a
simple nested IF statement, but when I leave the cell, it just sits
there
and
doesn't calculate the answer...it just shows the formula itself.
Here
is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem
when I
copied/pasted the values for the referenced cell so it was working
with
an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

Cool! That's a new one for me. Thanks for the info, Paul. I appreciate
your helpfulness!

Debbie

"PCLIVE" wrote:

This allows you to see all of your formula cells. Since you can't tell if a
cell contains a formula without clicking on them, it is difficult to find
those formula cells...especially if some of your formulas return blank
results.

Regards,
Paul

"Debbie" wrote in message
...
Thank you for responding. I did get the answer I was looking for, but I
was
wondering what Ctrl+~ does...

Thanks!

"PCLIVE" wrote:

Try pressing Ctrl+~

"~" is the symbol above the Tab key.


"Debbie" wrote in message
...
Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there.
BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
I'm using XL2000. I know...I'm way outdated. I have what seems to
be
a
simple nested IF statement, but when I leave the cell, it just sits
there
and
doesn't calculate the answer...it just shows the formula itself.
Here
is
my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem
when I
copied/pasted the values for the referenced cell so it was working
with
an
actual number.

What am I doing wrong???

Thanks for assisting!

Nested IFs Not Calculating
 

William, I went back and looked at your first response and I think I know
what I did. When I read the first line, it told me, in a literal sense that
"the cell ... must be formatted as text." Yes, I did see the part where you
said to change it to General, but I think my brain latched onto the literal
interpretation of your first sentence. Then I goofed up the process when
changing it to General, and that made my mind go right back to your first
sentence. I realize now that what you were actually telling me is that I
"must have formatted the cell as text in error" and it should be General.

Sorry I was a little thick in interpretting your first solution...that
really should have been the end of it!

Thanks again for all your help.

Debbie

"William Horton" wrote:

The cell that your formula is in must be formatted as text. Change the
format to General and then enter the formula again (or hit F2 and then
enter). Your formula should then calculate the appropriate answer.

Hope that helps.

"Debbie" wrote:

I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there and
doesn't calculate the answer...it just shows the formula itself. Here is my
formula:

=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))

Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.

What am I doing wrong???

Thanks for assisting!