Hello friends. I have a formula that I need to add a rounddown function to and don't know how to nest it. The formula is:
=IF(J29=0,"",1&":"&AVERAGE(IF(J12:J26=0,"",J12:J26)))
Any help would be appreciated. Thanks.
Hello friends. I have a formula that I need to add a rounddown function to and don't know how to nest it. The formula is:
=IF(J29=0,"",1&":"&AVERAGE(IF(J12:J26=0,"",J12:J26)))
Any help would be appreciated. Thanks.
Also, in case it helps the first potion of the formula up to the ":" is serving to avoid the 0 error and to tell Excel to display it as a 1: ratio. Everything after the ":" represents the potion of the formula where the averaging and rounding needs to occur. Thanks.
Mod, please move to functions. OP, please post in the correct place (this is your third formula question in Programming).
Please Login or Register to view this content.
Last edited by AlvaroSiza; 05-03-2012 at 11:50 AM.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thank you. Apologies for the incorrect placement. In the future I will post under functions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks