Thread: [Solved] Goalseek
View Single Post
 
Old 05-14-2013, 08:42 AM
franklinbukoski franklinbukoski is offline Windows 7 64bit Office 2007
Novice
 
Join Date: May 2013
Posts: 2
franklinbukoski is on a distinguished road
Default 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
Reply With Quote