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?
Microsoft Excel
Last Comment
Flyster
8/22/2022 - Mon
Flyster
You can use this formula:
=IF(A1<(B1/4),"Yes","No")
Flyster
MisUszatek
ASKER
I might need to change the percentage once in a while to a different value, let say 37%. How would that look like?
=IF(A1<(B1/4),"Yes","No")
Flyster