LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Applying formula on formula

I have used IF formula on 10 grid values to get desried values.Further, on
these values i want to apply average formula.
Whenever i apply the average onto the grid values, it show DIV#0.
I have to maually write the IF derived values in new column and apply the
average formula onto them. Please help.

 
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
Applying a cell format within a Formula BRMeter Excel Discussion (Misc queries) 2 August 21st 07 03:46 PM
Need help applying a formula to a certain area of the worksheet pirouz Excel Worksheet Functions 2 May 28th 06 01:28 AM
applying formula Pat N. Excel Discussion (Misc queries) 1 April 25th 06 08:47 PM
Applying a formula to an entire column Audrey Excel Discussion (Misc queries) 3 April 20th 06 07:26 PM
Applying colour to my Formula Ben Excel Discussion (Misc queries) 7 March 9th 06 04:30 PM


All times are GMT +1. The time now is 06:11 AM.

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"