hotelmrrsn
New Member
- Joined
- Apr 15, 2015
- Messages
- 3
I have a column of values:
460,683
441,249
107,800
89,406
I need a formula in another column that will tell me what value of 100 is needed to divide by in order to have the calculated result be <= 55%
For example, the 460,683 can be divided by 900 and multiplied by .1 to equal 51%. I need a way to figure the "900" part dynamically based on the column of values above. I might be way over complicating it but i'm just stuck. Any help/feedback is greatly appreciated.
Thank you!
Mike
460,683
441,249
107,800
89,406
I need a formula in another column that will tell me what value of 100 is needed to divide by in order to have the calculated result be <= 55%
For example, the 460,683 can be divided by 900 and multiplied by .1 to equal 51%. I need a way to figure the "900" part dynamically based on the column of values above. I might be way over complicating it but i'm just stuck. Any help/feedback is greatly appreciated.
Thank you!
Mike