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
Bookmarks