Hi,
I have a table below. I need to find out the 20% of "Numbers". If the 20% falls below 25, the result I need is either 25 (if column B is more than 25) or return the number in Column B if it's less than 25.
Example, Orange is 100. 20% of Orange is 20, but since the number is 100, it must return 25 in Column D. Papaya is only 4, so it must return 4 in Cloumn D.
By the way, the figure in Column C is rounded up.
Any formula suggestions would be most appreciated, but would prefer not to reference Column C as I'm using it as a guide only. Ultimately, will need to remove it from my spreadsheet.
Thanks!
I have a table below. I need to find out the 20% of "Numbers". If the 20% falls below 25, the result I need is either 25 (if column B is more than 25) or return the number in Column B if it's less than 25.
Example, Orange is 100. 20% of Orange is 20, but since the number is 100, it must return 25 in Column D. Papaya is only 4, so it must return 4 in Cloumn D.
By the way, the figure in Column C is rounded up.
Workers interview schedule.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | Item | Numbers | 20% | To buy | ||
3 | Apple | 150 | 30.0 | 30 | ||
4 | Orange | 100 | 20.0 | 25 | ||
5 | Grape | 250 | 50.0 | 50 | ||
6 | Cherry | 95 | 19.0 | 25 | ||
7 | Papaya | 4 | 1.0 | 4 | ||
8 | Mango | 6 | 2.0 | 6 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3:C8 | C3 | =ROUNDUP(B3*20%,0) |
Any formula suggestions would be most appreciated, but would prefer not to reference Column C as I'm using it as a guide only. Ultimately, will need to remove it from my spreadsheet.
Thanks!