Conditional Rounding Part deux

's Computer Specifications

How do I include $x.89 value in the below formula to add $0.05 with the $x.09
& $x.59 value?

> =INT((10*A1)+1)/10-0.01+(MOD(INT(A1*10)-(INT(A1)*10),5)=0)*0.05

's Computer Specifications

one way:

=INT((10*A1)+1)/10-0.01+OR(MOD(INT(A1*10)-(INT(A1)*10),5)=0,MOD(INT(A1*10)-(INT(A1)*10),8)=0)*0.05

"yk" wrote:

> How do I include $x.89 value in the below formula to add $0.05 with the $x.09
> & $x.59 value?
>
> > =INT((10*A1)+1)/10-0.01+(MOD(INT(A1*10)-(INT(A1)*10),5)=0)*0.05

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
#N/A part deux	sixthhole	Microsoft Excel Misc	4	17th Jan 2008 07:24 PM
Pics Part Deux	TriplexDread	General Discussion	4	30th Jul 2006 06:49 PM
Importing Part Deux	=?Utf-8?B?cm95X3dhcmU=?=	Microsoft Access External Data	3	6th Jan 2005 01:46 AM
Re: Re-installing Win XP HE (part deux)	Alex Nichol	Windows XP General	1	31st Jul 2004 03:51 PM
Re: Re-installing Win XP HE (part deux)	jt3	Windows XP General	0	29th Jul 2004 07:53 PM