Forum Discussion
round up
i have table were the values in Colum b,the first 20 increase by 5000 and the 10 000 and then 50 000 if i hava value of 116000 then the price in Colum of 120 000 must be use how do i write ...
It's not altogether clear what you're asking for. So let me just refer you to the ROUND and ROUNDUP functions, either one of which will be able to do what you're asking for. If you can't make them work, please come back with a clearer explanation. It's very clear in your mind, so I'm sorry it's not coming through clearly to me.
- Hi Mathetes, Hannes is looking for a formula that would use the larger value if the value falls between two values to return the higher cost.
- It was in April, half a year ago, that the question was asked. I'm going to assume it got answered one way or another.
mathetes I was looking for the same scenario and that is how I got to this discussion. It would be nice to see the answer to this discussion for future reference.
HansVogelaarmaybe you can help?
