Excel formula help

TheMSsForum.com: The Microsoft Software Forum

I've come up against a problem in Excel, I need help to figure out a
formula.

A B C D
1 Number Of Months 24 £60.00 £1,440.00
2 Number Of Weeks 96 £15.00 £1,440.00

I will try to make this clear to understand, what I need is when I change
cell C2 either adding more money or taking away, I need cell B2 to reflect
the change either increasing the amount of weeks needed to get to D2s total
or decrease depending on what was changed in C2.

Any advice or help would be much appreciated.
Top

Re: Excel formula help by Ken

Ken
Thu Oct 09 17:03:37 CDT 2008

On Oct 10, 8:21=A0am, "Anderson" <arsc1247...@blueyonder.co.uk> wrote:
> I've come up against a problem in Excel, I need help to figure out a
> formula.
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 A =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 B =A0 =A0 =A0 =A0 =A0 C =A0 =A0 =A0 =A0 =A0 =A0 =A0 D
> 1 =A0 =A0 Number Of Months =A0 =A0 24 =A0 =A0 =A360.00 =A0 =A0 =A31,440.0=
0
> 2 =A0 =A0 Number Of Weeks =A0 =A0 =A096 =A0 =A0 =A315.00 =A0 =A0 =A31,440=
.00
>
> I will try to make this clear to understand, what I need is when I change
> cell C2 either adding more money or taking away, I need cell B2 to reflec=
t
> the change either increasing the amount of weeks needed to get to D2s tot=
al
> or decrease depending on what was changed in C2.
>
> Any advice or help would be much appreciated.

Maybe, in B2...
C2/B2
which gives the exact number.

If it needs to be rounded up then...
=3DCEILING(C2/B2,1)

Ken Johnson
Top

Re: Excel formula help by Ken

Ken
Thu Oct 09 17:06:12 CDT 2008

On Oct 10, 9:03=A0am, Ken Johnson <KenCJohn...@gmail.com> wrote:
> On Oct 10, 8:21=A0am, "Anderson" <arsc1247...@blueyonder.co.uk> wrote:
>
> > I've come up against a problem in Excel, I need help to figure out a
> > formula.
>
> > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 A =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 B =A0 =A0 =A0 =A0 =A0 C =A0 =A0 =A0 =A0 =A0 =A0 =A0 D
> > 1 =A0 =A0 Number Of Months =A0 =A0 24 =A0 =A0 =A360.00 =A0 =A0 =A31,440=
.00
> > 2 =A0 =A0 Number Of Weeks =A0 =A0 =A096 =A0 =A0 =A315.00 =A0 =A0 =A31,4=
40.00
>
> > I will try to make this clear to understand, what I need is when I chan=
ge
> > cell C2 either adding more money or taking away, I need cell B2 to refl=
ect
> > the change either increasing the amount of weeks needed to get to D2s t=
otal
> > or decrease depending on what was changed in C2.
>
> > Any advice or help would be much appreciated.
>
> Maybe, in B2...
> C2/B2
> which gives the exact number.
>
> If it needs to be rounded up then...
> =3DCEILING(C2/B2,1)
>
> Ken Johnson

Oops! Wrong columns.
I meant...

=3DD2/C2 or =3DCEILING(D2/C2,1)

Ken Johnson
Top

Re: Excel formula help by Anderson

Anderson
Thu Oct 09 18:08:30 CDT 2008

It's working great now, thanks for your help :)

"Ken Johnson" <KenCJohnson@gmail.com> wrote in message
news:59a89aba-ecd7-467c-8b06-dd686bf18f25@e38g2000prn.googlegroups.com...
On Oct 10, 9:03 am, Ken Johnson <KenCJohn...@gmail.com> wrote:
> On Oct 10, 8:21 am, "Anderson" <arsc1247...@blueyonder.co.uk> wrote:
>
> > I've come up against a problem in Excel, I need help to figure out a
> > formula.
>
> > A B C D
> > 1 Number Of Months 24 £60.00 £1,440.00
> > 2 Number Of Weeks 96 £15.00 £1,440.00
>
> > I will try to make this clear to understand, what I need is when I
change
> > cell C2 either adding more money or taking away, I need cell B2 to
reflect
> > the change either increasing the amount of weeks needed to get to D2s
total
> > or decrease depending on what was changed in C2.
>
> > Any advice or help would be much appreciated.
>
> Maybe, in B2...
> C2/B2
> which gives the exact number.
>
> If it needs to be rounded up then...
> =CEILING(C2/B2,1)
>
> Ken Johnson

Oops! Wrong columns.
I meant...

=D2/C2 or =CEILING(D2/C2,1)

Ken Johnson


Top

Re: Excel formula help by Ken

Ken
Thu Oct 09 19:01:54 CDT 2008

On Oct 10, 10:08=A0am, "Anderson" <arsc1247...@blueyonder.co.uk> wrote:
> It's working great now, thanks for your help :)
>
> "Ken Johnson" <KenCJohn...@gmail.com> wrote in message
>
> news:59a89aba-ecd7-467c-8b06-dd686bf18f25@e38g2000prn.googlegroups.com...
> On Oct 10, 9:03 am, Ken Johnson <KenCJohn...@gmail.com> wrote:
>
>
>
> > On Oct 10, 8:21 am, "Anderson" <arsc1247...@blueyonder.co.uk> wrote:
>
> > > I've come up against a problem in Excel, I need help to figure out a
> > > formula.
>
> > > A B C D
> > > 1 Number Of Months 24 =A360.00 =A31,440.00
> > > 2 Number Of Weeks 96 =A315.00 =A31,440.00
>
> > > I will try to make this clear to understand, what I need is when I
> change
> > > cell C2 either adding more money or taking away, I need cell B2 to
> reflect
> > > the change either increasing the amount of weeks needed to get to D2s
> total
> > > or decrease depending on what was changed in C2.
>
> > > Any advice or help would be much appreciated.
>
> > Maybe, in B2...
> > C2/B2
> > which gives the exact number.
>
> > If it needs to be rounded up then...
> > =3DCEILING(C2/B2,1)
>
> > Ken Johnson
>
> Oops! Wrong columns.
> I meant...
>
> =3DD2/C2 or =3DCEILING(D2/C2,1)
>
> Ken Johnson

You're welcome.
Thanks for the feedback.

Ken Johnson
Top