Goalseek
Goalseek on cells containing formulas, I'd like to keep a cell's percentage below 50% (in cell h50) based on h48 (which uses a sum formula) and H50 (which divides H48/sum(h48,H49).
H48: =sum(i48:A448)
H50: =H48/sum(h48,H49)
I'd like to know how many more widgets I can have while remaining below 50%.
Thank you,
Frank
|