formula

  • Thread starter Thread starter James
  • Start date Start date
J

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.
 
=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.
 
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.
 
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))
 
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.
 
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)
 
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)




.
Click to expand...
 
Back
Top