Forum Discussion

hannesvdhitcoza's avatar
hannesvdhitcoza
Copper Contributor
Apr 19, 2021

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 ...
excel
Janedb's avatar
Janedb
Iron Contributor
Oct 13, 2021
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.
mathetes's avatar
mathetes
Gold Contributor
Oct 13, 2021
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.
  • Janedb's avatar
    Janedb
    Iron Contributor
    Oct 13, 2021

    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?

Resources