Hi,
How to create in cell formula to show in that cell number 1 when formula is correct. Formula will be to check if the number match number from diffrent cell.
Best regards
This question is not precise or clear enough to answer. Please edit the question to give a complete example and the desired result. See guidelines for asking.
=IF(D1; A1;"") (OR depending on language: =IF(D1, A1,"") ) This will check if the cell D1 contains a TRUE value and will return A1 otherwise will return an empty string. D1 contain the formula that will check and return TRUE or FALSE.
Going further =IF(ISERROR(D1); A1;"") (or any other checking function as: ISNA, ISERR …)