One possible way

=IF(H1<=10,H1+10,IF(AND(H110,H1<=500),H1*1.3,H1*1 .2))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"kssflmail" wrote in message
...
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