If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Averaging without #DIV0!
FSt1, Hi, again,
Once again, your on the money and your solution worked slick. Thank you and best regards, Malcolm "FSt1" wrote: hi vary your formula a tad =IF(c27=0,0,average(j28/c27)) thought i haven't seen the average formula used quite that way. but if c27 is zero then the above formual will put a zero in the cell instead of #DIV/0 regards FSt1 "Malcolm" wrote: I’m using a worksheet that has a cell (C27) that totals rooms and a cell (J28) that totals rates and a cell (J29) that is the average daily rate total, rate/total rooms. I’m using the formula =AVERAGE(J28/C27). The only problem is until I actually input a number into C27 I get the #DIV/0! displayed in my ADR cell (J29). I don’t always need this data so is there a way I can input the formula and not have the #DIV/0! in cell J29? Thanks, Malcolm |
#12
|
|||
|
|||
Averaging without #DIV0!
"Ziggy" wrote: On May 27, 3:33 pm, "Noodnutt @ Work" wrote: G'day Malcolm =IF($J28=0,0,AVERAGE(J28/C27)) HTH Mark "Malcolm" wrote in message ... I'm using a worksheet that has a cell (C27) that totals rooms and a cell (J28) that totals rates and a cell (J29) that is the average daily rate total, rate/total rooms. I'm using the formula =AVERAGE(J28/C27). The only problem is until I actually input a number into C27 I get the #DIV/0! displayed in my ADR cell (J29). I don't always need this data so is there a way I can input the formula and not have the #DIV/0! in cell J29? Thanks, Malcolm- Hide quoted text - - Show quoted text - It think when you divide you already creat the average. You don't need the AVERAGE function. =IF(C27=0,0,J28/C27) =IF(iserror(J28/C27),0,J28/C27) in 2007; =IFERROR(J28.C27,0) My preference runs to the if error formulas Sig Sig, Hi, Since I am using 2007, IFERROR does work great. Thanks, Malcolm . |
|
Thread Tools | |
Display Modes | |
|
|