What formula to change cell using IF(AND(

Brandon Morales

Im trying to create a formula that changes my status (Ref. Only) column to "test" if true and "ok" if false; When true means that reorder point is >= On Hand QTY AND Status column is blank…

is this possible?

Paul Newcome

The formula in your screenshot is close. Remove the @ from before "Status9" and then take one of the closing parenthesis from the end and move it to after the closing parenthesis following the ISBLANK function so that you close out the AND function before moving to the outputs of the IF.

=IF(………………………………., ISBLANK(Status9)), "TEST", "OK")

Brandon Morales

PERFECT. That fixed it- thank you!

Paul Newcome

The formula in your screenshot is close. Remove the @ from before "Status9" and then take one of the closing parenthesis from the end and move it to after the closing parenthesis following the ISBLANK function so that you close out the AND function before moving to the outputs of the IF.

=IF(………………………………., ISBLANK(Status9)), "TEST", "OK")

Brandon Morales

PERFECT. That fixed it- thank you!

Paul Newcome

Happy to help. 👍️