Replacing cell reference with a sum

[kylerisi]

Hi team,

I am struggling to work out how to replace C95 of my formula with (AVERAGE(B95:P95)

rather than dividing by the value of C95 I need to divide by the average of the numbers in range B95:P95

I just keep getting an parse error every time i paste (AVERAGE(B95:P95) in place of C95

Any help will be greatly appreciated

=iferror(if(C95="","",(if(C95>D95, concatenate(" +",text((C95-D95)/D95,"0%"),rept(" ",5),char(9650)),if(C95=D95,concatenate("0%",rept(" ",3),char(9668)," ",char(9658)),concatenate(text((C95-D95)/D95,"0%"),rept(" ",5),char(9660)))))),"◉")

Thanks

Kyle

 

[igold]

Hi,

I am not home but it looks like you are missing a closing bracket on your paste.