Hi,

i've inherited a spreadsheet that works out an indices. I'm having problems with #DIV/0! and correcting the formula. I've used an IF but to no joy. the formula is

=(((B2-B6)/B6)*100)+100

cells B2 and B6 both have the value 0.0% hence the #DIV/0!

can anyone help please?

Thanks