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