for example:
Column 1: has original value
Column 2: set value
Column 3: set percentage
Column 1 has 1000 and Columns 2 and 3 are empty
Enter 350 into Column 2 for the row - automatically calculates Column 3 value and sets it to 35 (calculated as C2Rx * 100 / C1Rx )
Enter 35 into Column 3 for the row - automatically calculates Column 2 value and sets it to 350 (calculated as C3Rx * C1Rx / 100 )
I can do this for one row using :
How can i do this for the whole column - or for a range from row 11 and above.Please Login or Register to view this content.
Moderator Edit:
Welcome to the forum, mcme.
Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.
Bookmarks