formula

[James]

I have a simple formula =IF(AD13>0,M13-AD13,M13-AB13) it
is returning the value or .01 I would like to round to
zero and amount less than .02. I would like to round to
to .00. Can anyone Help me. I appreciate any help you can
give me.

 

[Peo Sjoblom]

=IF(Value<0.02,ROUND(Value,0),Value)

will round values less than 0.02 to zero
Don't know what you mean by .00.

 

[Guest]

Hi, I am really not with it how do I put this in my
formula? =IF(AD13>0,M13-AD13,M13-AB1. Thank you for
helping me.

 

[Frank Kabel]

Hi
one way: try
=IF(IF(AD13>0,M13-AD13,M13-AB1)<0.02,ROUND(IF(AD13>0,M13-AD13,M13-AB1))
,IF(AD13>0,M13-AD13,M13-AB1))

 

[Guest]

Thank you for your input, but it does not work, it tells
me I have to few arguements. Germany, it is amazing to me
how many people are associated with this group. Thank you
for your help.

 

[JE McGimpsey]

I suspect Frank meant

=IF(IF(AD13>0,M13-AD13,M13-AB1)<0.02,ROUND(IF(AD13>0,M13-AD13,M13-AB1),0)
,IF(AD13>0,M13-AD13,M13-AB1))

another way would be

=(M13-IF(AD13>0,AD13,AB13)) * ((M13-IF(AD13>0,AD13,AB13))>=0.02)

 

[Frank Kabel]

Hi JE
missed that parameter
thanks for the correction

 

[Guest]

Thank you, it works!!!

-----Original Message-----
I suspect Frank meant

=IF(IF(AD13>0,M13-AD13,M13-AB1)<0.02,ROUND(IF(AD13>0,M13- AD13,M13-AB1),0)
,IF(AD13>0,M13-AD13,M13-AB1))

another way would be

=(M13-IF(AD13>0,AD13,AB13)) * ((M13-IF (AD13>0,AD13,AB13))>=0.02)




.