training ms excel advanced - Excel IF command

Resolved · Low Priority · Version Standard

Fri 23 Feb 2007, 09:33 Delegate Angela said...

Angela has attended:
Excel Intermediate course
Excel Advanced course

Excel IF command

how to use the IF commands

Fri 23 Feb 2007, 10:32 Trainer Tracy said...

RE: excel IF command

The IF function is based on a true or false scenerio, an example would be

=IF(A1>100, "Above target", "Under target")

dependent on whether the first condition (A1>100) is true the function will reveal the word Above target, and if is not true it will reveal the word Under target.

You have to put speech marks in if you want to reveal text, however if you want to put numbers you can leave the speech marks out.

For example

=IF(A1<1000, 20, 10)

So this would be interpreted as if the contents of A1 were less than 1000 it will give the number 20(i.e if the condition A1<1000 were true), if not it will give the answer 10.

Hope that helps, if there is anything specific you need to know get back to me

Thanks

Tracy

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips