Excel XP Nested If Function Problem

  • Thread starter Thread starter DaffyD®
  • Start date Start date
D

DaffyD®

Using Excel XP to use nested IF function, I keep getting the "+" sign when
clicking on the IF button to add a nested IF formula. I found that this
creates incorrect False answers. I then have to manually change the "+" to a
comma. How can I get Excel to display a comma between the formulas by
default. And what is the difference between "+" and a comma when placed
between nested IF formulas?
 
I'm not sure what the IF button is, but I could use ctrl-click and xl2002 put in
a comma, then the address of the cell I clicked.
 
This didn't work. Thanks for the response.

The IF button is displayed at the left end of the formula bar after the IF
function is started. There's a down arrow button beside it which is used to
access the other paste functions. This may be different in 2002 since the
formula bar is slightly different (paste function is located on the formula
bar and doesn't have it's own button on the Toolbar. However, I have this
same problem when using Excel 2000. Haven't used 2002.
 
I can kind of duplicate this in xl2002.

If I type =If
then hit the Functions button (that's the tooltip that popped up when I let my
cursor linger over it), then I ended up with:
=if(+if()
in the formula bar

But if I typed =if(
then clicked, I got this:
=if(IF()

If I just typed the equal sign (=), then selected the IF function, it worked ok.

But if you're typing, you could leave your fingers on the keyboard, type:
=if(
and hit ctrl-A
to have the function wizard show up.
<<even a plain old =if worked ok, too.>>

And someday when you still want the reminder, but not the wizard, hit
ctrl-shift-A.

Am I close?


DaffyD® said:
This didn't work. Thanks for the response.

The IF button is displayed at the left end of the formula bar after the IF
function is started. There's a down arrow button beside it which is used to
access the other paste functions. This may be different in 2002 since the
formula bar is slightly different (paste function is located on the formula
bar and doesn't have it's own button on the Toolbar. However, I have this
same problem when using Excel 2000. Haven't used 2002.
Click to expand...
 
I wouldn't call it an IF button, it is whatever function was used the last
time.
The reason you get a plus (I believe) is that when you click again on that
button
it thinks you want to add another if function. One way to bypass that is to
start with
the fx button, select IF and do the first step in the boxes, in the logical
test box click the
cell, then in the if TRUE box type the result you want if it's true, now
place cursor
in the if FALSE box, then click the IF button and you'll see that it puts a
comma there and
starts with a new clean dialogue box and so on..

--

Regards,

Peo Sjoblom

DaffyD® said:
This didn't work. Thanks for the response.

The IF button is displayed at the left end of the formula bar after the IF
function is started. There's a down arrow button beside it which is used to
access the other paste functions. This may be different in 2002 since the
formula bar is slightly different (paste function is located on the formula
bar and doesn't have it's own button on the Toolbar. However, I have this
same problem when using Excel 2000. Haven't used 2002.


Dave Peterson said:
I'm not sure what the IF button is, but I could use ctrl-click and
Click to expand...
xl2002
put in
a comma, then the address of the cell I clicked.
Click to expand...
"+"
to a
Click to expand...
 
Thank you for the information but I couldn't duplicate these with XP.
However, Peo came up with the solution I was looking for.
 
You're right about the button, I just call it the IF button when using that
function because that's what it displays. However, you nailed it--you gave
me the answer I was looking for. Funny thing is, I had already done it
before (comma between two IF formulas) but had no idea how I did it. Thanks
again.

Peo Sjoblom said:
I wouldn't call it an IF button, it is whatever function was used the last
time.
The reason you get a plus (I believe) is that when you click again on that
button
it thinks you want to add another if function. One way to bypass that is to
start with
the fx button, select IF and do the first step in the boxes, in the logical
test box click the
cell, then in the if TRUE box type the result you want if it's true, now
place cursor
in the if FALSE box, then click the IF button and you'll see that it puts a
comma there and
starts with a new clean dialogue box and so on..

--

Regards,

Peo Sjoblom
Click to expand...
 
First, glad you found your answer. But what part couldn't you duplicate?



DaffyD® said:
Thank you for the information but I couldn't duplicate these with XP.
However, Peo came up with the solution I was looking for.
Click to expand...
 
Back
Top