98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » If statements
If statements
Resolved · High Priority · Version 2007
Mon 9 Mar 2009, 11:25Delegate Nicola said...
Nicola has attended:
Excel Advanced course
Access Intermediate course
If statements
I have a column which contains either yes or is blank. Can i use an if statement so that in another column I can put a value if it says yes?
e.g what I tried was =IF(I4=YES, 100, 0) but this gives a name error.
What should I have done?
Mon 9 Mar 2009, 13:30Trainer Carlos said...
RE: If statements
Hi Nicola
In the function it should say I4="YES" as seen below:
=IF(I4="YES", 100, 0)
This way you are telling the computer to look for the string (word) YES.
In your example it was looking for a named range called YES.
Hope this helps
Carlos
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. |
Excel tip:Counting Non Number Cells (Text)If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values. |
