If statements with currency positive and negative and needing value

sholmes

I'm having to try to create several formulas so that I can in turn create triggers. I need to say if there is a value in cell A with a difference of $1 (positive or negative) from cell A and cell B I want it to say notify, if not say no. Anyone have a suggestion. I had

=IF([Cash Distribution (AM)]@row - [Received Cash Distributions (FM)]@row >= 1, "notify", "No")

which works but doesn't take account of a value or the negative $1.

Thanks in advance!

Paul Newcome

Try an ABS function. This makes all numbers (positive and negative) positive numbers. This should do the trick for you.

=IF(ABS([Cash Distribution (AM)]@row - [Received Cash Distributions (FM)]@row) >= 1, "notify", "No")

sholmes

Thanks, it still is giving me an issue if the cell is blank. Sometimes all files are not in so if it's blank I don't want it to run the formula, only run when a value is added. Is that possible?

Paul Newcome

Give this a go then:

=IF(AND([Cash Distribution (AM)]@row <> "", [Cash Distribution (FM)]@row <> ""), IF(ABS([Cash Distribution (AM)]@row - [Received Cash Distributions (FM)]@row) >= 1, "notify", "No"))

sholmes

Thanks, it didn't work - give me the unparseable error?

Paul Newcome

I may have mistyped a column name. Double check those first.