Forum Discussion
Volume range, apply % in formula
Hello. I am working on figuring out a formula that I can apply in excel. The logic is basically, if the volume is within a specific range, then the formula is X * (1- %). I have attached a example of my dilemma. HansVogelaar
Yes, it works. In your sample there are values within the range. In general LOOKUP function - Microsoft Support
However, it'll be an error if the volume value is less than 100000. If that's the case, add to your volume ranges the one from zero to 100000. Another point, volume ranges are to be in ascending order.
To be more flexible you may use XLOOKUP function - Microsoft Support, variant for it is attached file.
6 Replies
I actually did not phrase this correctly. Please see attached file instead.
There is no attachment. You may share through OneDrive, Google Drive, etc if attachment option is not available here. In general like
= IF( (V>=Rmin)*(V<=Rmax), X*(1-%), X )SergeiBaklan pls find attached excel file.
