Excel formula help

[Anderson]

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.

 

[Ken Johnson]

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

 

[Ken Johnson]

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

 

[Anderson]

It's working great now, thanks for your help

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

 

[Ken Johnson]

It's working great now, thanks for your help







Oops! Wrong columns.
I meant...

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

Ken Johnson

You're welcome.
Thanks for the feedback.

Ken Johnson