SOLVED

# IF statement showing result over and over

Copper Contributor

# IF statement showing result over and over

I've got an IF statement that should be displaying a result of OK if the check is valid.  Right now, it displays the OK or NG message repeatedly, so the cell shows OKOKOKOKOKOK... instead of just "OK".  I don't see why this is happening, especially when other checks are just printing "OK" once.  What could be going on?

The offending check:

=IF(C22-C28 >= (MAX(1,VLOOKUP(C20,\$A56:\$C66,2,FALSE),VLOOKUP(C26,\$A56:\$C66,2,FALSE))),"OK","NG")

A check that works:

=IF(C22<=C14,"OK","NG")

2 Replies
best response confirmed by Katarn5 (Copper Contributor)
Solution

# Re: IF statement showing result over and over

Select the cell with the formula.

On the Home tab of the ribbon, click the arrow in the lower right corner of the Alignment group.

Has the horizontal alignment been set to Fill? If so, select another option, such as General or Center.

# Re: IF statement showing result over and over

Thank you, that worked!
1 best response

Accepted Solutions
best response confirmed by Katarn5 (Copper Contributor)
Solution

# Re: IF statement showing result over and over

Select the cell with the formula.

On the Home tab of the ribbon, click the arrow in the lower right corner of the Alignment group.

Has the horizontal alignment been set to Fill? If so, select another option, such as General or Center.