Goalseek

[franklinbukoski]

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