Trouble with dividing and multiplying cells

  • Thread starter Thread starter Celeste Nelson
  • Start date Start date
C

Celeste Nelson

I need a formula that can do what is below and put the
results into column b like shown..

A B
Amount Results Below is the math problem...

23.86 1.67 (23.86 divided by 75.66) X 5.30 = 1.67

23.86 1.67 (23.86 divided by 75.66) X 5.30 = 1.67

23.86 1.67 (23.86 divided by 75.66) X 5.30 = 1.67

4.08 0.29 (4.08 divided by 75.66) X 5.30 = 0.29

Total 75.66
 
If I'm understanding you correctly, assume your data begins in A1, then use
the following formula in B1:

=A1/75.66*5.3

and copy down as far as you need.

HTH
 
Back
Top