Hi,
I need a formula to get two results depending on the search values of the Customer and the Revenue.
The Customer is any positive value but all values which are equal to 4 or greater are treated as 4.
The Revenue to be considered is within a range as shown in the table in column F.
So as in my example, if Customer is 2 and the Revenue is 3005 then the returned Price is 0,7 and the Bonus is 1.
Many thanks in advance
for Price (cell B7 insert formula below)
for Bonus (cell B9 insert formula below)
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Syrkrasi; 02-17-2017 at 12:29 PM.
How about this, in B7:
B9:Please Login or Register to view this content.
Please Login or Register to view this content.
Quang PT
Another way...
re-arrange your table, thus
2Matches.jpg
and with formula in A5
Formula:
Please Login or Register to view this content.
and formula in A7
=INDEX($F$3:$J$8,MATCH(B3,E3:E8,1),5)
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Wow cool, many thanks to everybody!
Sorry for the late answer due to the fact that I was ill and not in office.
you are welcome
If your problem is solved please go to Thread Tools (top of thread) and mark the thread as "solved". thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks