Excel formula not working

I have a excel sheet where I am trying to get results based on some values user seelcts from the drop-down box. But for some reason my one cell is not outputing the correct values. It seems it is showing the same value no matter when I change the value in the dropdown box. Can somebody please help me resolve this issue. Cell E16 is the formula which is not working and the formula is =(671*(E13*100/E5))/100. I have attached the excel sheet
calc.xlsx
zolfAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

小桂 陳Commented:
E13 =>  ROUND(E5/((E7/E6)+1),0)  

then

E16 = 228.14000
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RaminTechnical AdvisorCommented:
I checked it and it works fine.  if you don't change E6 and E7 values then the result in E16 will not change even if you change E5.  because E5 and E13 have a direct relation ( if you double or triple E5 then E13 also will double or triple) and since one of them is numerator and the other is denominator so the result will keep intact.  if you don't change E6 and E7 then always (E13/E5)=3 even if you change E5 value.

Check the file:
Test.xlsx
0
zolfAuthor Commented:
Thanks for all your comments!!.

小桂 陳

Your feedback on changing the E13 did the trick, and now when I change the value in E5, I get the E16 values as expected. What was the issue can you please comment on it.

Ramin

what you mentioned is what was my issue and wanted to resolve it. The reason is when I do the calculation on paper, I get the values but with excel it was not giving me those vvalues. But as 小桂 陳 commented, changing the folrmula for E13 did the tricl
0
zolfAuthor Commented:
Please comment,cheers!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.