Can I make a cell equal a formula under one condition but be blank under another condition? I

Question

Can I format a cell as a formula if the value of another cell is numeric but leave it blank if the value of that other cell is an alphanumeric code?

Answer 1

Hi @Gregory I

Could you please share us with a simple sample that show more deatils, such as the results you need.

Now, I would suggest you try the IF and ISNUMBER functions firt.

On the below image, if the data in cell B1 is numeric, then give the cell in the same row A1 a formula "B1+2“, if not then A1 is blank.

Any misunderstandings, you can post back.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---