I need a formula to calculate 1.5% on the first $750 and an additional 1% on
anything over $750.
--
cardfan057

"cardfan057" wrote:
I need a formula to calculate 1.5% on the first $750 and
an additional 1% on anything over $750.

=1.5%*MIN(750,A1) + 1%*MAX(0,A1-750)

assuming that A1 contains the number.

With data in cell A1:

=A1*1.5%+(MAX(0,1%*(A1-750)))


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=539162

That did it, thanks
--
cardfan057


"CaptainQuattro" wrote:


With data in cell A1:

=A1*1.5%+(MAX(0,1%*(A1-750)))


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=539162

Hi Mate,

Try this:

=IF(F25750,(750*1.5%)+(F25-750*1%),(F25*1.5%))

Thanks
Gazzr


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539162