I'm looking for a 3 variable formula for a single cell using figures from 8
cells in a column for Exel 2003. Basically, totalling variable fees for 8
different cells. If for example H1 is under (<) $10.00, then add 10.00 to the
total. If H1 is over () 10.01 then multiply that figure by 30% and add that
figure to total. If H1 is over 500.00 then multiply that figure by 20%.
Having all cells figures added to one cell based on previous mention variables