IF statement showing result over and over

Copper Contributor

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:


2 Replies
best response confirmed by Katarn5 (Copper Contributor)


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.

Thank you, that worked!