Excel 2003: rounding down and capping

Originally Posted by seanof30306

EDIT: OK, I've solved the rounding down issue with the following formulae:

Tip Pool: "=ROUNDDOWN(G13*0.1,0)"

Taxes: "=ROUNDDOWN((G13-J13)*0.35,0)"

It works perfectly. I still need to know how to cap the tip pool contribution at 20.00, though

Try this:

=MIN(ROUNDDOWN(G13*0.1,0),20)

Does that help?