G
Guest
I am trying too average some test scores and sometimes one of those numbers
can be zero. I read that the AVERAGE function will ignore blank cells, so I
tried to use an IF statement to change the zeros to blank cells. Here is what
I tried.
=AVERAGE(IF(D109:F109=0,"",D109:F109))
Any help would be greatly appreciated.
Thanks
Greg Ruff
can be zero. I read that the AVERAGE function will ignore blank cells, so I
tried to use an IF statement to change the zeros to blank cells. Here is what
I tried.
=AVERAGE(IF(D109:F109=0,"",D109:F109))
Any help would be greatly appreciated.
Thanks
Greg Ruff