Hello! I'm looking for help with a formula.
I've included a screenshot. I have an initial value (in the screenshot, it's 103%). Now, I want to find where in the Min and Max columns that number falls between. If it falls between a range of numbers, it should return the corresponding value in column "payout %"
For this example, the value returned should be 120%.
Screen Shot 2022-11-07 at 1.59.52 PM.png
Thanks so much!
Last edited by laurend7; 11-07-2022 at 03:47 PM.
Hi. Welcome to the forum.
Maybe something like this:
=IF(AND(Min<=initial value,Max>=initial value),Payout,"")
Where Min is the first cell under Min heading; Max, the first cell under Max heading and Payout the first cell under Payout heading.
Then copy down.
Should that fail, please follow instructions on yellow banner above to upload a sample workbook.
Good luck!
Thanks Estavaoba. That Formula did not work. I have attached a sample workbook
You're welcome.
The formula above was for a helper column next to I, on cell J10, for example, then dragged down to J19, which would result 50% in cell J17.
But you can try this other formula in cell A13:
Formula:
Please Login or Register to view this content.
Reverse your look up table so that the lowest value to highest values. Then use the Vlookup function in A13
=VLOOKUP(B5,G10:I19,3,TRUE)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
That worked, thank you so much
You're welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks