Trying to figure out how to make this happen. Please see the attached excel file
B20 is the number of projects awarded in a year.
C7 is I bid 10 jobs to get 2 so 20% like shown in E8
What I need to do is be able to enter 10 in cell C7 and 2 in E7 and the calculation would be
performed in cell B8 showing how many jobs I need to bid to to win what is in B2
So even if I put 100 in cell B2 and I put 5 in E7 the calculation in B8 needs to tell me how
many projects I need to Bid to equal the number placed in B2
Much Appreciated!
Bookmarks