Nov 14 2023 01:29 PM
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")
Nov 14 2023 02:56 PM
SolutionSelect 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.