0

I'm having trouble figuring out a formula. I need to find out if the number in Cell B is greater than 10% of the number in cell A. If it is, I want Cell C to say Yes.

Improve this question
3
  • I think I figured it out. =IF(B1>A1*1.1,"Yes","No")
    – Cp11111
    Aug 15, 2014 at 15:59
  • 1
    Correct. you can also =IF(B1>A1*1.1,"Yes","") if you jsut want C to be blank if it's not Yes.
    – Tyson
    Aug 15, 2014 at 16:12
  • 1
    10% (i.e. one tenth) of the value in cell A1 is A1 * 0.1.
    – Andrew Morton
    Aug 15, 2014 at 17:08

1 Answer 1

Reset to default
0

Post to close. Wiki for no rep.

Per the comments:

=IF(B1>A1*1.1,"Yes","No")
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .