LinkBack URL
About LinkBacks
I want to have a formula in cell N7 where the number will be divided by the years selected in the dropdown list and otherwise 0 for other years
I want to have a formula in cell N7 where the number will be divided by the years selected in the dropdown list and otherwise 0 for other years
Do you mean this?
=IFERROR(I9/H17,0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yes, but I am looking for a more dynamic approach.
So the formula should only show division result upto 5 years otherwise 0 for the rest of the years ; division result up to 10 years if selected 10 otherwise 0 and so on
Without the benefit of seeing some manually calculated results, this is my guess:
Paste the following into cell N7 and drag the fill handle to the right: =IF(SUM($N6:N6)=$H17,$I9/$H17,0)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks