IF formula with allowable variance

I need to write a formula that will put Yes in the column if the Quote and Invoice values are within $5 of each other, or if the Quote Frequency is recurring.

Here is what I have so far, but I can't figure out how to add the allowable variance of $5

=IF(OR([Quote Amount]13 = [Invoice Amount]13, [Quote Frequency]13 = "Recurring - Monthly"), "Yes", "No")

Thanks!

Find more posts tagged with

Finance

Formulas

Comments

Paul Newcome

Try something like this...

=IF(OR(INT([Quote Amount]@row - [Invoice Amount]@row) <= 5, [Quote Frequency]@row = "Recurring - Monthly"), "Yes", "No")

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…