Forum Discussion
Soni James
Nov 12, 2018Copper Contributor
Excel Ceiling and Max formulas
I need to create a spreadsheet to calculate how much change to make for my register. These are the columns I have: Column A: Currency denomination Coulmn B: Current total in cash drawer. Col...
Lorenzo Kim
Nov 12, 2018Bronze Contributor
try:
=IFERROR(MAX(0;CEILING(D8;10;1)),0)
HTH
=IFERROR(MAX(0;CEILING(D8;10;1)),0)
HTH