I am trying to use the following formula and I am getting the #VALUE! error. Any thoughts:
=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,"",J12:J26),0)))
Thanks
I am trying to use the following formula and I am getting the #VALUE! error. Any thoughts:
=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,"",J12:J26),0)))
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks