IF function

Resolved · Low Priority · Version 2007

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

Erglend has attended:
Excel Advanced course

IF function

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

Fri 13 Nov 2009, 13:44 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

IF function

IF function

RE: IF function

Excel articles

Excel tip:

Select Single Data Marker

Training Programs
Professional & Management Development