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
=if
Resolved · Medium Priority · Version 2010
Sat 19 May 2012, 20:44Delegate Michael said...
Michael has attended:
Excel Intermediate course
Excel Advanced course
=if
I attended an intermediate excel May 9th and I wrote the following formula but it comes out #name? so i am doing something wrong - can anyone help
=if(a1="michael", "helllo michael", "intruder")
Thanks
Mon 21 May 2012, 09:07Trainer Mark said...
RE: =if
Hello Michael,
Looking at your formula there is nothing wrong with it, and when I copy it to my spreadsheet, it works as it should. I can only suggest that you check on your sheet you have the "quote" marks around each word otherwise it will give the NAME error.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Mon 28 May 2012: Automatically marked as resolved.
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:Generate randon numbersSome types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it: |
