LinkBack URL
About LinkBacks
I'm trying to figure out how to nest a ROUNDDOWN function in the following formula:
=IF(E29=0,"",1&":"&AVERAGE(E29,J29,O29,T29,Y29,AD29,AI29))
The string of AVERAGE numbers is the portion that needs rounding. Any ideas?
I'm trying to figure out how to nest a ROUNDDOWN function in the following formula:
=IF(E29=0,"",1&":"&AVERAGE(E29,J29,O29,T29,Y29,AD29,AI29))
The string of AVERAGE numbers is the portion that needs rounding. Any ideas?
Like:
=IF(E29=0,"",1&":"&INT(AVERAGE(E29,J29,O29,T29,Y29,AD29,AI29)))
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks