=VALUE(cell)

[jackthompson]

Hi,

im trying to make a formula filled spreadsheet for document review.

I'm about there but now I am getting a #VALUE! on my icon conditioned column.

looking at it, this would be because the =VALUE() formula hasn't got anything to pull through.
Cann you use a =value() else "" or something along those lines to bring back blank if no value instead of an error.

 

[Simon4s]

right now you have =value(A1)

Change to:
=if(isnumber(A1),value(A1),"")

 

[jackthompson]

That worked a treat, as you can tell I'm an excel formula novice

 

[bbott]

Another option:

=IFERROR(VALUE(A1),"")