If statement

[DEBORAHELLEN30]

I am trying a formula and am lost...

If a number (specific number R5 for example) is ten percent greater than another number (specific number K5 for example)then put a yes in a specific column if it is not put a no in a different column... I am trying to put yes in one column and no in another...

Please help

THANKS!!!!!!!!!!!!!!

 

[SteveO59L]

=if(r5>(k5*1.1),"Yes","No")

 

[Joe4]

If you are looking for exactly 10% greater, try:
=IF(R5=(K5*1.1),"Yes","No")

If you are looking to see if it is at least 10% greater, try:
=IF(R5>=(K5*1.1),"Yes","No")