If formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janie - 04 Apr 2008 22:13 GMT

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.

Reply to this Message

PCLIVE - 04 Apr 2008 22:26 GMT

Try this:

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

HTH,
Paul

>I am trying to find an if formula that says if the result of A-B is less
>than
[quoted text clipped - 10 lines]
> as negative.
> Any help would be appreciated.

Reply to this Message

Dave - 04 Apr 2008 23:03 GMT

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.

Reply to this Message

Rate this thread: