=if

Resolved · Medium Priority · Version 2010

Sat 19 May 2012, 20:44 Delegate 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:07 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Generate randon numbers

Some 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:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips