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

Question

question

GregoryI-7016 asked Apr 12, '22 emilyhua-msft commented Apr 18, '22

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

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?

office-excel-itpro

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-13T03:08:23.233Z

emilyhua-msft answered Apr 13, '22 emilyhua-msft commented Apr 18, '22

Hi @GregoryI-7016

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.

capture96.jpg (14.9 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft · Apr 18 at 07:09 AM

Hi @GregoryI-7016
I am checking this thread, is there any update?
If yes, please feel free to post back.

0 ·

question