• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Conditional formatting formula comparing two columns

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?
0
MisUszatek
Asked:
MisUszatek
  • 2
1 Solution
 
FlysterCommented:
You can use this formula:

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

Flyster
0
 
MisUszatekAuthor Commented:
I might need to change the percentage once in a while to a different value, let say 37%. How would that look like?
0
 
FlysterCommented:
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.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now