PDA

View Full Version : hide #value!



Martinw
11-23-2012, 12:05 AM
I want empty cells to be blank instead of showing #value!

The formula is =VALUE(SUBSTITUTE(BD1,"Shortened Odds","")).

I have tried modifying =IF(ISERROR(SUM((H10-G10)/G10)),"",SUM((H10-G10)/G10)) but it is not working and help is not helpful

Any help would be greatly appreicated

Ta,
Martin

Bob Phillips
11-23-2012, 07:08 AM
If the formula is

=VALUE(SUBSTITUTE(BD1,"Shortened Odds",""))

why on earth would you try

=IF(ISERROR(SUM((H10-G10)/G10)),"",SUM((H10-G10)/G10))

No is no correlation that I can see.

Martinw
11-23-2012, 11:20 AM
I was trying to use the format, as below :-

=IF(ISERRORVALUE(SUBSTITUTE(BD1,"Shortened Odds","")),"",VALUE(SUBSTITUTE(BD1,"Shortened Odds","")))

but it did not work.

Any ideas?

Bob Phillips
11-23-2012, 11:41 AM
It should be

=IF(ISERROR(VALUE(SUBSTITUTE(BD1,"Shortened Odds",""))),"",VALUE(SUBSTITUTE(BD1,"Shortened Odds","")))

Martinw
11-23-2012, 05:44 PM
Hi,
Thanks for that - I should have counted the ")"
Ta,
Martin