Comparing to Columns if Less Than a Percentage Yes

[ryanb4614]

Hello-

I am working on a spreadsheet to compare year to date sales column A and column B previous year to date sales. I want to compare these columns. If there is a drop in sales by 25% I want the cell to be marked as "Yes" and "No" if not. I have the formula if Column A is less than Column B to show yes/no but I am not sure how to work in the percentage comparison.

[ChemistB]

Maybe

=IF((B2-A2)/A2 <-25%,"Yes","No")

[ryanb4614]

Maybe

=IF((B2-A2)/A2 <-25%,"Yes","No")

Thank you. If A2= 0 I get a formula error. Any idea?

[ChemistB]

How do you calculate the percent increase if the original value is 0? Mathematically, it's an infinite percent increase.
To just have Excel not perform the calculation if A2 is 0, try

=IF(A2=0,"", IF((B2-A2)/A2 <-25%,"Yes","No"))

[ryanb4614]

How do you calculate the percent increase if the original value is 0? Mathematically, it's an infinite percent increase.
To just have Excel not perform the calculation if A2 is 0, try

=IF(A2=0,"", IF((B2-A2)/A2 <-25%,"Yes","No"))

Attachment 732981

So the first column with the formula has the new formula and the second column with the formula has the original formula you provided. Sorry for the confussion.

[josephteh]

Formula=IF(B2=0,"No",IF((A2-B2)/B2>-25%,"No","Yes"))

[ryanb4614]

Formula=IF(B2=0,"No",IF((A2-B2)/B2>-25%,"No","Yes"))

Thank you that did it. Obvious now

[josephteh]

You are welcome. Please take a moment to mark the thread as "Solved" using the thread tools menu above your first post. Have a blessed day!

[josephteh]

You may also like to thank everyone by clicking the Add Reputation button at the bottom-left corner of any of the posts of all members who took time to help you.