Shows #Value!

S

Steved

Steved
I have #Value! in a cell with no data

I put the below formula in to ask the cell to be blank

What is needed for it to work please.

=IF(ISERROR(VALUE(LEFT($F$6,1))),VALUE(LEFT($F$6,1)))
 

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

Can This formula give 2 choices 10
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Newbie Help - IF Yes No Function 0
Need a ) somewhere in ISERROR formula but don't know where to put it 3
Copy columns, but not hidden ones 3
Lookup Across Multiple Rows / Columns 5
VLOOKUP & Data Validation 0
Calculate the median value before a specified list 0

Top