On Jul 8, 7:10 pm, clintjjohnson wrote:
I've changed the formula slightly to accomodate this (where 130.77 is in cell
F6): ((D6-F6-102)*10%...

Yes, that works. But it is "inefficient" because you must do D6-F6 in
so many places. Then again, in a small worksheet, it is unlikely that
you will notice the extra microseconds (or multi-nanoseconds) on
today's fast CPUs. So whatever seems clearer and easier for you is
the thing to do.

One further tweak would be nice - how do I prevent it from displaying
anything in its cell if D6 (the gross income) is empty?

=if(D6="", "", round(max(...),2))