Prev: Date inconsistent help please :)
Next: Date Help
From: Malcolm on 27 May 2010 19:55
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
> >
From: Malcolm on 28 May 2010 08:38


"Ziggy" wrote:

> On May 27, 3:33 pm, "Noodnutt @ Work" <ma...(a)camerons.com.au> wrote:
> > G'day Malcolm
> >
> > =IF($J28=0,0,AVERAGE(J28/C27))
> >
> > HTH
> > Mark
> >
> > "Malcolm" <Malc...(a)discussions.microsoft.com> wrote in message
> >
> > news:B9AACD7C-6185-43B7-A52F-DAEF11B769E1(a)microsoft.com...
> >
> >
> >
> > > 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
> .
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Date inconsistent help please :)
Next: Date Help