Problem with formula, I think I am missing something.

I have 2 columns of numbers, Column A and Column B then in a third column, Column C, I would like to show if column B is less than or equal to 10% of column A. I am using the below formula, but it isn't working out the way I need it to.

Please Login or Register  to view this content.

Any help would be greatly appreciated. And Thanks in advance.

LOL, Nevermind I just figured something out...

Originally Posted by Pepe Le Mokko

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

ok I will remember that for future posts but thanks anyway

You just need to swap the formula around
=IF(B1<=(A1*0.1),"10%","")
It will then work

Originally Posted by TomB1

You just need to swap the formula around
=IF(B1<=(A1*0.1),"10%","")
It will then work

Yeah thats what I figured out :-P

And Thank you very much tho.