Forum Discussion
Solved
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")
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.
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!
