| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get rid of #DIV/0! without repeating denominator?
I have some very long denominator formulas and these formulas are repeated
many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
I you're using Excel 2007 it's pretty easy:
=IFERROR(your_formula(...),"") If the formula does not return #DIV/0! what is the typical range of results you expect? Would a result of 0 be OK instead of blank? -- Biff Microsoft Excel MVP "Go Bucks!!!" wrote in message ... I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
Hi T, Its just a simple average formula. I wanted to perform the same work as the IF(denominator = 0,""), but I didnt want to have to write out the whole denominator formula. This is exactly what I was looking for. Zero or Blank works great. Thanks!!! "T. Valko" wrote: I you're using Excel 2007 it's pretty easy: =IFERROR(your_formula(...),"") If the formula does not return #DIV/0! what is the typical range of results you expect? Would a result of 0 be OK instead of blank? -- Biff Microsoft Excel MVP "Go Bucks!!!" wrote in message ... I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Go Bucks!!!" wrote in message ... Hi T, Its just a simple average formula. I wanted to perform the same work as the IF(denominator = 0,""), but I didnt want to have to write out the whole denominator formula. This is exactly what I was looking for. Zero or Blank works great. Thanks!!! "T. Valko" wrote: I you're using Excel 2007 it's pretty easy: =IFERROR(your_formula(...),"") If the formula does not return #DIV/0! what is the typical range of results you expect? Would a result of 0 be OK instead of blank? -- Biff Microsoft Excel MVP "Go Bucks!!!" wrote in message ... I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator? For older versions ofExcel
Your advice gave me an idea to replicate the new formula provided in 2007 in older version of Excel.
Copy the following code into one of the worksheet modules to get the same capabilities as the function provided in 2007 : Function IFERROR(Formula1a, Alternate1a) ' Formula1a is the formula to test for errors ' Alternate1a is the variable returned if an error is ' detected ' iferror Macro ' temp1a = Formula1a If IsError(temp1a) Then iferror = Alternate1a Else iferror = Formula1a End If ' End Function T. Valko wrote: Get rid of #DIV/0! without repeating denominator? 02-Oct-09 I you are using Excel 2007 it is pretty easy: =IFERROR(your_formula(...),"") If the formula does not return #DIV/0! what is the typical range of results you expect? Would a result of 0 be OK instead of blank? -- Biff Microsoft Excel MVP Previous Posts In This Thread: On Friday, October 02, 2009 5:36 PM Go Bucks!!! wrote: Get rid of #DIV/0! without repeating denominator? I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, On Friday, October 02, 2009 6:28 PM T. Valko wrote: Get rid of #DIV/0! without repeating denominator? I you are using Excel 2007 it is pretty easy: =IFERROR(your_formula(...),"") If the formula does not return #DIV/0! what is the typical range of results you expect? Would a result of 0 be OK instead of blank? -- Biff Microsoft Excel MVP On Friday, October 02, 2009 6:28 PM JoeU2004 wrote: "Go Bucks!!! That depends on the revision of Excel that you want to design for. Excel 2007 has an IFERROR function. Otherwise, I would compute the denominator in a helper cell, which can be hidden. ----- original message ----- On Friday, October 02, 2009 6:36 PM Ro wrote: Is the cause of the error #DIV/0 always caused by the same cell of column? Is the cause of the error #DIV/0 always caused by the same cell of column? As a suggestion, you could preceed your formula with something like =IF(D16=0,"",your formula) or =IF(SUM(C:C)=0,"",your formula) "Go Bucks!!!" wrote: On Saturday, October 03, 2009 2:12 AM Ashish Mathur wrote: Hi,If you want to conceal the error value, you may make use of conditional Hi, If you want to conceal the error value, you may make use of conditional formatting. In Format Conditional formatting Formula Is, type the following formula =iserror($A4). This assumes that the first cell is $A4 Now click on Format and colour the font to white. Click on OK twice. Now copy the cell and paste special conditional formatting in the cells below Please note that this technique will only colour the font to white I.e. the value in the cell will still be an error. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com On Monday, October 05, 2009 9:16 AM Go Bucks!!! wrote: The IFERROR works for me, but this is a very clever approach Ashish. The IFERROR works for me, but this is a very clever approach Ashish. Instead of spending a lot of time trying to fix a problem - format it away. I love it. Thanks! "Ashish Mathur" wrote: On Monday, October 05, 2009 9:19 AM Go Bucks!!! wrote: Hi T,Its just a simple average formula. Hi T, Its just a simple average formula. I wanted to perform the same work as the IF(denominator = 0,""), but I didnt want to have to write out the whole denominator formula. This is exactly what I was looking for. Zero or Blank works great. Thanks!!! "T. Valko" wrote: On Monday, October 05, 2009 9:31 AM Ashish Mathur wrote: Glad you liked it-- Regards,Ashish MathurMicrosoft Excel MVPwww.ashishmathur. Glad you liked it -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com On Monday, October 05, 2009 12:12 PM T. Valko wrote: You're welcome. Thanks for the feedback!-- BiffMicrosoft Excel MVP"Go Bucks!!! You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP Submitted via EggHeadCafe - Software Developer Portal of Choice Parallel Programming in C# 4.0: A Short Synopsis http://www.eggheadcafe.com/tutorials...ming-in-c.aspx |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
Your advice gave me an idea to replicate the new formula provided in 2007 in older version of Excel.
Copy the following code into one of the worksheet modules to get the same capabilities as the function provided in 2007 : Function IFERROR(Formula1a, Alternate1a) ' Formula1a is the formula to test for errors ' Alternate1a is the variable returned if an error is ' detected ' iferror Macro ' temp1a = Formula1a If IsError(temp1a) Then iferror = Alternate1a Else iferror = Formula1a End If ' End Function T. Valko wrote: Get rid of #DIV/0! without repeating denominator? 02-Oct-09 I you are using Excel 2007 it is pretty easy: =IFERROR(your_formula(...),"") If the formula does not return #DIV/0! what is the typical range of results you expect? Would a result of 0 be OK instead of blank? -- Biff Microsoft Excel MVP Previous Posts In This Thread: On Friday, October 02, 2009 5:36 PM Go Bucks!!! wrote: Get rid of #DIV/0! without repeating denominator? I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, On Friday, October 02, 2009 6:28 PM T. Valko wrote: Get rid of #DIV/0! without repeating denominator? I you are using Excel 2007 it is pretty easy: =IFERROR(your_formula(...),"") If the formula does not return #DIV/0! what is the typical range of results you expect? Would a result of 0 be OK instead of blank? -- Biff Microsoft Excel MVP On Friday, October 02, 2009 6:28 PM JoeU2004 wrote: "Go Bucks!!! That depends on the revision of Excel that you want to design for. Excel 2007 has an IFERROR function. Otherwise, I would compute the denominator in a helper cell, which can be hidden. ----- original message ----- On Friday, October 02, 2009 6:36 PM Ro wrote: Is the cause of the error #DIV/0 always caused by the same cell of column? Is the cause of the error #DIV/0 always caused by the same cell of column? As a suggestion, you could preceed your formula with something like =IF(D16=0,"",your formula) or =IF(SUM(C:C)=0,"",your formula) "Go Bucks!!!" wrote: On Saturday, October 03, 2009 2:12 AM Ashish Mathur wrote: Hi,If you want to conceal the error value, you may make use of conditional Hi, If you want to conceal the error value, you may make use of conditional formatting. In Format Conditional formatting Formula Is, type the following formula =iserror($A4). This assumes that the first cell is $A4 Now click on Format and colour the font to white. Click on OK twice. Now copy the cell and paste special conditional formatting in the cells below Please note that this technique will only colour the font to white I.e. the value in the cell will still be an error. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com On Monday, October 05, 2009 9:16 AM Go Bucks!!! wrote: The IFERROR works for me, but this is a very clever approach Ashish. The IFERROR works for me, but this is a very clever approach Ashish. Instead of spending a lot of time trying to fix a problem - format it away. I love it. Thanks! "Ashish Mathur" wrote: On Monday, October 05, 2009 9:19 AM Go Bucks!!! wrote: Hi T,Its just a simple average formula. Hi T, Its just a simple average formula. I wanted to perform the same work as the IF(denominator = 0,""), but I didnt want to have to write out the whole denominator formula. This is exactly what I was looking for. Zero or Blank works great. Thanks!!! "T. Valko" wrote: On Monday, October 05, 2009 9:31 AM Ashish Mathur wrote: Glad you liked it-- Regards,Ashish MathurMicrosoft Excel MVPwww.ashishmathur. Glad you liked it -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com On Monday, October 05, 2009 12:12 PM T. Valko wrote: You're welcome. Thanks for the feedback!-- BiffMicrosoft Excel MVP"Go Bucks!!! You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP On Thursday, May 13, 2010 4:21 AM Chris Oosthuizen wrote: Get rid of #DIV/0! without repeating denominator? For older versions of Excel Your advice gave me an idea to replicate the new formula provided in 2007 in older version of Excel. Copy the following code into one of the worksheet modules to get the same capabilities as the function provided in 2007 : Function IFERROR(Formula1a, Alternate1a) ' Formula1a is the formula to test for errors ' Alternate1a is the variable returned if an error is ' detected ' iferror Macro ' temp1a = Formula1a If IsError(temp1a) Then iferror = Alternate1a Else iferror = Formula1a End If ' End Function Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Binding Beyond the Limitation of Name Scopes http://www.eggheadcafe.com/tutorials...nd-the-li.aspx |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
"Go Bucks!!!" wrote:
I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? That depends on the revision of Excel that you want to design for. Excel 2007 has an IFERROR function. Otherwise, I would compute the denominator in a helper cell, which can be hidden. ----- original message ----- "Go Bucks!!!" wrote in message ... I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
Is the cause of the error #DIV/0 always caused by the same cell of column?
As a suggestion, you could preceed your formula with something like =IF(D16=0,"",your formula) or =IF(SUM(C:C)=0,"",your formula) "Go Bucks!!!" wrote: I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
Hi,
If you want to conceal the error value, you may make use of conditional formatting. In Format Conditional formatting Formula Is, type the following formula =iserror($A4). This assumes that the first cell is $A4 Now click on Format and colour the font to white. Click on OK twice. Now copy the cell and paste special conditional formatting in the cells below Please note that this technique will only colour the font to white I.e. the value in the cell will still be an error. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Go Bucks!!!" wrote in message ... I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
The IFERROR works for me, but this is a very clever approach Ashish.
Instead of spending a lot of time trying to fix a problem - format it away. I love it. Thanks! "Ashish Mathur" wrote: Hi, If you want to conceal the error value, you may make use of conditional formatting. In Format Conditional formatting Formula Is, type the following formula =iserror($A4). This assumes that the first cell is $A4 Now click on Format and colour the font to white. Click on OK twice. Now copy the cell and paste special conditional formatting in the cells below Please note that this technique will only colour the font to white I.e. the value in the cell will still be an error. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Go Bucks!!!" wrote in message ... I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of #DIV/0! without repeating denominator?
Glad you liked it
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Go Bucks!!!" wrote in message ... The IFERROR works for me, but this is a very clever approach Ashish. Instead of spending a lot of time trying to fix a problem - format it away. I love it. Thanks! "Ashish Mathur" wrote: Hi, If you want to conceal the error value, you may make use of conditional formatting. In Format Conditional formatting Formula Is, type the following formula =iserror($A4). This assumes that the first cell is $A4 Now click on Format and colour the font to white. Click on OK twice. Now copy the cell and paste special conditional formatting in the cells below Please note that this technique will only colour the font to white I.e. the value in the cell will still be an error. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Go Bucks!!!" wrote in message ... I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT repeating the denominator? =IF((denominator formula)=0,"",(numerator formula/denominator formula). One of my actual formulas broken down is... =IF DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)) =0,"", NUMERATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*('Call Activity'!$Q:$Q=1)) / DENOMINATOR... (SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))))))) Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zero denominator | Excel Worksheet Functions | |||
| Is there a formula to calculate the least common denominator? | Excel Worksheet Functions | |||
| lowest common denominator | Excel Worksheet Functions | |||
| How to cause the value in the denominator change with changing row | Excel Discussion (Misc queries) | |||
| specify denominator in fraction | Excel Discussion (Misc queries) | |||
![Go Bucks!!![_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
