Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

IF function

Resolved · Low Priority · Version 2007

Reply Thu 12 Nov 2009, 16:05Delegate Erglend said...

Erglend has attended:
Excel Advanced course

IF function

Can if function be used with string values in a cell ?

For upcoming training course dates see: Pricing & availability

Reply Fri 13 Nov 2009, 13:44Trainer Simon said...

RE: IF function

Hi Erglend,

Thank you for your question.

If you are creating IF functions you can refer a string.

Here is an example:

=if(H2="Brown",h8*2.5,h8*3.5)

I hope this answers your question.

Regards

Simon

Fri 20 Nov 2009: Automatically marked as resolved.

Excel articles

· How To Create A Real Line Graph In Excel 2010 Rather Than A Line Chart
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010
· How To Create A Macro In Excel 2010
· Find Out How To Create That Missing Link With Excel
· Microsoft Excel Training Course

Please browse our web site to find out more about
basic training excel and other Microsoft training courses.

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips