LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help fast - creating pop ups mward77095 Excel Discussion (Misc queries) 3 May 8th 06 08:55 PM
I need major help fast!!!!! Mr. Jay Excel Discussion (Misc queries) 3 March 10th 06 04:22 PM
OH, I need help fast.(Excel-Adobe) DKR Excel Discussion (Misc queries) 3 November 4th 05 08:53 PM
Need help fast! [email protected] Excel Discussion (Misc queries) 2 October 1st 05 04:10 AM
Need help fast! Thanks! spectator Excel Discussion (Misc queries) 4 July 27th 05 07:01 AM


All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"