Trouble with dividing and multiplying cells

[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

 

[Michael J. Malinsky]

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