Excel formula help

  • Thread starter Thread starter Anderson
  • Start date Start date
A

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.
 
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.
Click to expand...

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

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

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
Click to expand...

Oops! Wrong columns.
I meant...

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

Ken Johnson
 
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
Click to expand...

Oops! Wrong columns.
I meant...

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

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
Click to expand...

You're welcome.
Thanks for the feedback.

Ken Johnson
 
Back
Top