How can I get rid this value "#VALUE!" in the cell

V

vitality

hi all.

Due to the unknown cell value in some cell, I have some cell come u
with "#VALUE!" in the side.

Is there any functions can delete the "#VALUE!" value?

I try the if statement, but fail。

thanks for your help

Vitalit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
want to track time while paste value in multiple column of same roe 1
vba code help for multiple string searching 0
If function across sheets prints value of cell 4
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Help with Address(), Indirect(), Offset 2
Testing cell value for greater than 0 1
Excel Need Countifs Formula Help 0

Top