If statements with currency positive and negative and needing value

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!

Find more posts tagged with

Formulas

Accepted answers

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"))

All comments

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.

sholmes

Thanks

Paul Newcome

Happy to help. 👍️

sholmes

Hey @Paul Newcome I was wondering if you could help me with the is blank formula. I am not sure what I am missing but I want it to ignore if the cell is blank. Here is what I am using:

=IF(ABS([Anticipated Fed TC (FM)]@row - [Federal Credits]@row) > 10, "Alert", "Ok", IF(ISBLANK)([Federal Credits]@row), "Ok")

Paul Newcome

@sholmes You just need to remove the closing parenthesis immediately after ISBLANK.

sholmes

I need it was something simple that I was overlooking. Thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.