Combining formulas with If, IsBlank, ABS, Isnumber & RoundUp

Hi Guys,

In the attached file in columns G, H, I & J, I have tried to use combinations of the above functions. I have arrived at the desired results for each with the exception of H9 & I11. These relate to columns C & B which are blank, I need the two blanks (H9 & I11) to each become 1.00.

Also, alhough in the main columns G, H, I & J are giving expected results, are the formulas that I have "concocted" acceptable and robust?

There are more notes on the worksheet.

TIA
Keith