Forum home » Delegate support and help forum » Microsoft Excel Training and help » =if

=if

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

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

=if

=if

RE: =if

Excel articles

Excel tip:

Turn Function tooltips on and off