We will be migrating from Ask to Discourse on the first week of August, read the details here

# Write number to cell if same number exist in diffrent cell [closed]

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

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2021-05-09 21:50:42.419118

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.

( 2018-05-19 17:49:23 +0200 )edit

Sort by » oldest newest most voted

This post is a wiki. Anyone with karma >75 is welcome to improve it.

=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 ...)

more