I have a cell with a formula in it. When I try to add an IF statement to the
end of the formula, as soon as I type the "I" a dialog box pops up and says
"There is more than one cell with this label", and refers to the label "I".
The dialog box want me to choose which cell the labe lrefers to, but I have
no idea what it means. I don't have any cells labelled "I". If I cancel out
the dialog box, Excel then crashes.

Sounds a bit strange. Could you post a little more detail e.g. what is the
formula and how are you adding the IF statement to it?

"judanna77" wrote:

I have a cell with a formula in it. When I try to add an IF statement to the
end of the formula, as soon as I type the "I" a dialog box pops up and says
"There is more than one cell with this label", and refers to the label "I".
The dialog box want me to choose which cell the labe lrefers to, but I have
no idea what it means. I don't have any cells labelled "I". If I cancel out
the dialog box, Excel then crashes.

The formula that is already in the cell is
IF(OR(AND(Retirees!$GX2=3,Retirees!$GX2<=6),AND(R etirees!$GX2=9,Retirees!$GX2<=12)),ROUND(Retirees !HQ2*IF(AND(Retirees!$GU2="C",OR(Retirees!BC2Reti rees!Q2,Retirees!$BK2=1)),0.5,1)*Retirees!$GP2,2), 0)

When I click on the cell and put my cursor at the end of the formula, I type
" + I". As soon as I type the "I", the dialog box comes up. It doesn't just
happen in this one cell; it happens in all the cells on this page. However,
if the cell doesn't already have a formula in it, I can type the IF statement
without getting the dialog box.

I can get around this by either copying and pasting the word "IF" or by
setting the calculation options to not accept labels in formulas. However,
neither of these are very satisfying since they don't solve the real problem.

Any ideas?

"bigwheel" wrote:

Sounds a bit strange. Could you post a little more detail e.g. what is the
formula and how are you adding the IF statement to it?

"judanna77" wrote:

I have a cell with a formula in it. When I try to add an IF statement to the
end of the formula, as soon as I type the "I" a dialog box pops up and says
"There is more than one cell with this label", and refers to the label "I".
The dialog box want me to choose which cell the labe lrefers to, but I have
no idea what it means. I don't have any cells labelled "I". If I cancel out
the dialog box, Excel then crashes.