Need help on Formula

[mutedf8]

Hi All,

I need help on finding a formula to fix below issue.


The Total quantity of below listed products is 1000/-.

I need to set a formula , so that if i change the total quantity to say 10,000/- each of my products quantity needs to be changed accordingly. Your help will be highly appreciated.

10.3 - product 1
20.7 - product 2
206.6 - product 3
20.7
3.1
413.0
4.1
5.2
31.0
72.3
5.2
25.8
31.0
105.4
5.2
5.2
3.1
5.2
2.1
4.1
20.7

---------
1000




thanks in advance.

[tamthat]

Hi All,

I need help on finding a formula to fix below issue.


The Total quantity of below listed products is 1000/-.

I need to set a formula , so that if i change the total quantity to say 10,000/- each of my products quantity needs to be changed accordingly. Your help will be highly appreciated.

10.3 - product 1
20.7 - product 2
206.6 - product 3
20.7
3.1
413.0
4.1
5.2
31.0
72.3
5.2
25.8
31.0
105.4
5.2
5.2
3.1
5.2
2.1
4.1
20.7

---------
1000




thanks in advance.

Is it ok? @@

[mutedf8]

Is it ok? @@

thanks for your help.

the formula is good & this is what i was looking for. However, only the first product's quantity is changing. how to use the formula to all other items. should i need to do this manually for each item? because i have about 100+ products

[tamthat]

oh, download again pls or change $A$1 =>> $A1

[JohnTopley]

Works fine for me: set your new total to 2000 and all values are doubled.

[mutedf8]

oh, download again pls or change $A$1 =>> $A1

Once again, thank you.

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)