If formula

[Janie]

I am trying to find an if formula that says if the result of A-B is less than
..03 then 0 but if the result is less than 0 (example -.03) than show result.
The reasoning may help. We don't want to be bothered with amounts less than
3 cents but we do want to display the credit balances because we have to
refund the amount.
Another way of trying to explain what I am trying to do is if the result of
A-B is either .01,.02,.03, than just make it 0 but if it is -.01 show result
as negative.
Any help would be appreciated.

 

[PCLIVE]

Try this:

=IF(OR(A1-B1={0.01,0.02,0.03}),0,A1-B1)

HTH,
Paul

 

[Dave]

Hi Janie,
Try this formula:
=IF(AND(A1>0;A1<0,4);0;A1)
This formula gets its info from Cell A1.
You will have to change each "A1" to the reference of the approprite cell in
your sheet.
If it produces an error, use
=IF(AND(A1>0,A1<0.4),0,A1)
Regards - Dave.