Conditional formatting formula comparing two columns

MisUszatek
MisUszatek used Ask the Experts™
on
I have 3 columns (A, B and C) in Excel 2010. I need to put text YES in the C column if A is less than 25% of B and text NO if it is more than 25%. What is the best way to do it?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can use this formula:

=IF(A1<(B1/4),"Yes","No")

Flyster

Author

Commented:
I might need to change the percentage once in a while to a different value, let say 37%. How would that look like?
If you want to hard code it you can use:

=IF(A1<(B1*0.37),"Yes","No")

Or, you can use a reference cell:

=IF(A1<(B1*D1),"Yes","No")

Just put your .37 in cell D1. A little more flexibility that way.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial