Thanks:  0
Likes:  0

1. Total Units Destroy Remaining %
100 99 1 100%

I'm dividing the Remaining by the Total to obtain the %. I need to change each % that less than 250% and make it 250%, in which case I would have to alter the Destroy #. Is there a formaula that can assist me rather than doing it manually?

Thanks!!

Anthony

2. I am not clear on your question.
Do you mean 25%

New Column C =MAX(B2,0.75*A2-B2)
Remaining % =(A2-B2-C2)/A2

3. Thanks for responding Dave! I did mean 250%. I actually have 5 columns.

Total Sellable Destroy Remaining %
100 30 50 50 167%

I'm dividing the Remaining by the Sellable to obtain the %. I would need to change the 50 (Destroy Column) to 25 in order to obtain the desired 250%. Does this make more sense?

Thanks again!!!

Anthony

4. On 2002-03-25 21:29, Anthony G. wrote:
Thanks for responding Dave! I did mean 250%. I actually have 5 columns.

Total Sellable Destroy Remaining %
100 30 50 50 167%

I'm dividing the Remaining by the Sellable to obtain the %. I would need to change the 50 (Destroy Column) to 25 in order to obtain the desired 250%. Does this make more sense?

Thanks again!!!

Anthony
Hi Anthony:
If your Total, Sellable,Destroy, Remaining,% are in cells A2,B2,C2,D2,and E2,
then for 250pct you need to put the following formula in F2

=IF(E2<250%,D2*250%/E2,E2)

HTH
Please post back if it works for you ... otherwise explain a little further and let us take it from there!

5. Purely arithmetic ......

With 30 in B6
Remaining =B6*250%
% =G5/B5 250%

new column Revise =B5*250%-D5
new col G new Remaining =D5+F5

% =G5/B5 250%

6. Dave and Yogi............Thanks!!!!

Worked just fine.

Anthony

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•