Thread
:
Change divisor if column is 0
View Single Post
#
2
Posted to microsoft.public.excel.misc
Barb Reinhardt
external usenet poster
Posts: 3,355
Change divisor if column is 0
Try using =Average(A1:C1)
"Carol Mac" wrote:
D1=(A1+B1+C1)/3
If A1, B1 or C1 have a 0 value, can the divisor change automatically so that
it only divides by the number of columns with a value? Thanks.
Reply With Quote
Barb Reinhardt
View Public Profile
Find all posts by Barb Reinhardt