Dividing then multiplying multiple numbers

[suertetres]

I'm trying to write a formula that starts by dividing two numbers and multiplying that by several subsequent numbers. For example. A1/B1*C1*D1*E1*F1


I've tried many and keep getting various errors and suspect my lack of math knowledge is the issue.

 

[Peter_SSs]

In what way is your formula failing?

23 11 16.xlsm
	A	B	C	D	E	F	G
1	100	50	2	3	4	2	96
suertetres

Cell Formulas
Range	Formula
G1	G1	=A1/B1*C1*D1*E1*F1

 

[suertetres]

I'm trying to back into a number. I'm coming up with 1,284,862 and the number I'm supposed to be at is 128.

Here are the values I'm trying
139.63/151.99*.62*67.44*77.59*431.10

 

[suertetres]

I figured it out! I was missing the percentage. It was calculating whole numbers.

 

[Peter_SSs]

Cheers, glad you got it sorted. Thanks for letting us know.

For the future, I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.