excel 2002....

  • Thread starter Thread starter John
  • Start date Start date
J

John

I need to sum a column and minus 2.5 % up to maximum of $30.00
will need to be an if formula
so far I have =SUM(U8:U43)
should be something like this...=SUM(U8:U43),IF(<=1200*.025,-30)
 
I need to sum a column and minus 2.5 % up to maximum of $30.00
will need to be an if formula
so far I have =SUM(U8:U43)
should be something like this...=SUM(U8:U43),IF(<=1200*.025,-30)
Click to expand...
Maybe something like this would work,
=IF((SUM(U8:U43)*0.025)>30,SUM(U8:U43)-30,SUM(U8:U43)*0.975)
 
=MIN(SUM(U8:U43)*(1-2.5%),300)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi,

Another formula that also works is

=MAX(SUM(U8:U43)-30,9.75%*SUM(U8:U43))
 
Back
Top