Forum home » Delegate support and help forum » Microsoft Excel Training and help » If statements
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
If statements
Resolved · Low Priority · Version 2003
Reply Thu 26 Feb 2009, 12:45Delegate Stacy said...
Stacy has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
If statements
I am trying to enter a simple If statement whereby if cell L2 equals nm then I want the current cell (AQ) to say Red.
I am using the usual format that I use but I keep getting a name error. I was wondering if somone could help me and tell me what is wrong with my formula
=If(L2=nm, "red")
For upcoming training course dates see: Pricing & availability
RE: If statements
Hello Stacy
Thank you for your question.
The IF function always needs three parts to work, therefore because this formula is missing the value_if_false part, the formula won't work.
As you don't want Excel to put anything in the cell if L2 doesn't equal nm, then use:
=If(L2=nm, "red","")
The double quotation marks "" tell Excel to leave the cell blank if L2 does not equal nm.
Kind regards
Amanda
Thu 5 Mar 2009: Automatically marked as resolved.
|