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
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