Share via

Excel Formula

Anonymous
2022-12-17T22:45:19+00:00

I have two columns (a variance and percentage) that can be either positive or negative:

Variance %

(4,786.53) 779%

(984.29) 763%

2,433.33 -17%

2,000.00 20%

If the variance either positive or negative is greater than or equal to $1,000 and the percentage either positive or negative is greater than or equal to 10%, I need to return True or if it is not then False or blank.

Microsoft 365 and Office | Excel | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-12-17T22:57:30+00:00

Hi LG

Please, try the formula =AND(ABS(A2)>=1000,ABS(B2)>=10%)

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Regards

Jeovany

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-17T23:13:54+00:00

    Thank you! That is exactly what I needed.

    Was this answer helpful?

    0 comments