Hi All,
Please can you have a look at the attached file where I am trying to create the bucket based on the salary, however I am not been allowed by IF Statement to add more conditions.
I am not sure whats missing here to stop me.
Thank you.
Hi All,
Please can you have a look at the attached file where I am trying to create the bucket based on the salary, however I am not been allowed by IF Statement to add more conditions.
I am not sure whats missing here to stop me.
Thank you.
You actually are allowed to next way more than what you have there.
The problem is not the nesting - you dont have a 3rd argument for the last IF statement.....
=IF(A7<=$K$4,$L$4,IF(AND(A7>=$J$5,A7<=$K$5),$L$5,IF(AND(A7>=$J$6,A7<=$K$6),$L$6,?????????)))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
if you explain the rules here, we may be able to come up with another option.
Hi Ford. My requirement is based on Salary it should pick the GBP. Currently the salary is not greater than 595k but in future the salary might change, so thinking to extend the formula to pick. Does my rule make sense.
Dont use nested ifs for this a vlookup is the way to go, then you can easily find the number and make the list longer or change the Greater then values for yearly inflation.
For this function you also only need the Greater then colomn to test for the treshold for the next bucket. you can remove the less then colomn if you want (then change the 3 into a 2 for 3rd parameter) or you can keep it for visual referencePlease Login or Register to view this content.
the key in thos formula is setting the last parameter of VLOOKUP to 1 or TRUE this will put each value upto and including 258.733,21 in the 50.000 bucket and when larger then that amount it will show 75.000.
Last edited by Roel Jongman; 04-30-2021 at 01:55 AM.
Thank Roel and Ford for your help and advice. I will try and let you know.
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks