A1 = amount entered EXP: There is an existing formula for A1 that generates an amount based on other cells. For the purpose of this formula, I simply need an add on formula to calculate the following once this number is already generated from the existing formula. Lets say the number generated from the existing formula = 100
B1 = percentage entered EXP: 25%
Worksheet!C1 = the remaining percentage difference from what was entered into B1 * A1. In this case B1=25% so Worksheet!C1 answer should be 75% * 100 = 75 and A1 should now = 25.
2nd Example:
If the formula answer for A1 is 500 based on the formula prior, then when I enter 60% into B1,
A1 & Worksheet!C1 should populate the follow:
A1 = 300
B1=60%
Worksheet!C1 = 200
Bookmarks