hide #value!

[Martinw]

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]

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]

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]

It should be

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

[Martinw]

Hi,
Thanks for that - I should have counted the ")"
Ta,
Martin