Fill in a cell value based on a condition

Microsoft Ms sla excel lic/sa 2yr-1
January 23, 2010 at 15:03:14
Specs: Windows 7, 4 MB
If cell a1 is 15 then cell b1 should be filled with "Yes" if it is more than 15 it should be filled in with "No". I would like to do this in the IF statement in Excel. Currently cell b1 is empty.

See More: Fill in a cell value based on a condition

Report •

January 23, 2010 at 15:51:34
You will find that people are more willing to help if you actually ask for help instead of just stating what you want to do. A "Please" and "Thank you" go a long way in this forum.

Please review the Excel Help files for the IF function. They explain how to build a Nested IF statement.

To get the results you want, this might work:


Since you didn't say what you want to see if A1 is <15, this formula will give you an empty cell in that case.

Report •
Related Solutions

Ask Question