| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formula help fast please!!
I have a spreadsheet that gives an average percentage number ( =average(b5:G5)
but if nothing is entered I want it to show 0.00% How to I make it show that?? Thanks!!! Meenie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula help fast please!!
I assume you mean B5:G5 are empty?
=IF( ISERROR(AVERAGE(B5:G5)),0,AVERAGE(B5:G5)) "Meenie" wrote: I have a spreadsheet that gives an average percentage number ( =average(b5:G5) but if nothing is entered I want it to show 0.00% How to I make it show that?? Thanks!!! Meenie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula help fast please!!
try this idea. And, in the future, please remember that "fast please" will
turn some off to your request. Also, please state the gist of your problem in the subject line such as, "Average formula error" =IF(ISERR(AVERAGE(P5:P10)),"",AVERAGE(P5:P10)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Meenie" wrote in message ... I have a spreadsheet that gives an average percentage number ( =average(b5:G5) but if nothing is entered I want it to show 0.00% How to I make it show that?? Thanks!!! Meenie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula help fast please!!
Thank you so much, guys.
I finally figured out a formula that works although your's is probably much more sophisticated than mine I used: =IF(COUNTA(C3:G3)=0,"0.00%",AVERAGE(C3:G3)) Does that look ok? It seems to work, lol :) Thanks, Meenie "Meenie" wrote: I have a spreadsheet that gives an average percentage number ( =average(b5:G5) but if nothing is entered I want it to show 0.00% How to I make it show that?? Thanks!!! Meenie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need formula help fast please!!
You are returning 0.00% as a text value - this might cause some
problems elsewhere in the sheet if you intend to do some arithmetic with it. Hope this helps. Pete On Jul 26, 4:00 pm, Meenie wrote: Thank you so much, guys. I finally figured out a formula that works although your's is probably much more sophisticated than mine I used: =IF(COUNTA(C3:G3)=0,"0.00%",AVERAGE(C3:G3)) Does that look ok? It seems to work, lol :) Thanks, Meenie "Meenie" wrote: I have a spreadsheet that gives an average percentage number ( =average(b5:G5) but if nothing is entered I want it to show 0.00% How to I make it show that?? Thanks!!! Meenie- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help fast - creating pop ups | Excel Discussion (Misc queries) | |||
| I need major help fast!!!!! | Excel Discussion (Misc queries) | |||
| OH, I need help fast.(Excel-Adobe) | Excel Discussion (Misc queries) | |||
| Need help fast! | Excel Discussion (Misc queries) | |||
| Need help fast! Thanks! | Excel Discussion (Misc queries) | |||
Linear Mode
