Hello. I will soon be calculating retail pricing. If the sum is, for
example, $2.01 we need to take it down to a more acceptable retail
price of $1.99. I will have a huge spreadsheet with thousands of
amounts to convert. Can this be easily done?

Thanks so much!


--
kapper
------------------------------------------------------------------------
kapper's Profile: http://www.excelforum.com/member.php...o&userid=33644
View this thread: http://www.excelforum.com/showthread...hreadid=534143

calculate actual price minus integer of price

eg 1.99 minus 1 = .99
eg 2.02 minus 2 = .02

then if(difference<.05,oldprice-difference-.01, oldprice)


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=534143

This formula works as well:
=ROUNDDOWN(A1,0)-0.01
.... where A1 holds the 2.01 entry.

That'll work! Tested fine.
Thanks for your help!


--
kapper
------------------------------------------------------------------------
kapper's Profile: http://www.excelforum.com/member.php...o&userid=33644
View this thread: http://www.excelforum.com/showthread...hreadid=534143

"Dave O" wrote in message
oups.com...
This formula works as well:
=ROUNDDOWN(A1,0)-0.01
... where A1 holds the 2.01 entry.

Yes, providing your margins will allow you to round $2.99 down to $1.99.
--
David Biddulph