Hi Joan

Try
=H65*0.6+(MAX(0,H65-700000)*0.08)+(MAX(0,H65-1400000)*0.02)

This multiplies the whole value by 60% and adds a further 8% (to that
60%) for all value that exceeds 700,000 and a further 2% ( to the 60% +
8%) for the value that exceeds 1,400,000

--
Regards

Roger Govier


"Joan" wrote in message
...
My workbook has numerous worksheets each representing a new week of
sales.
Each worksheet shows the previous total sales and the current week's
sales to
arrive at the total todate sales.
If total revenue is equal or under $700,000, then the multiplying
factor is
$0.60. At 700,001 to 1,400,000 the multiplying factor is $0.68.
1,400,001 and over the multiplying factor is $0.70.

cell Current week Prior week Total to date
(D65) 2,388.75 (F65) 995,360.00 (H65) 997,748.75

The formula is if
(H65<=700000,H65*0.6,if(H65<=1400000,700000*0.6+(H 65-700000)*0.68,700000*1.28+(H65-1400000)*0.7))-'wk2
apr3'!F87-'Wk1 mar26'!F87

H65 represents total sales to date. The result of this formula is in
cell
F87.
Using this formula however, I need to subtract all the previous weeks'
formula results and so the formula is getting very large as we go on .
Any suggestions?
Joan