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

Excel function

ResolvedVersion 2003

Mon 28 Jul 2008, 16:41 Delegate Daniela said...

Daniela has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Excel function

was a nested if function

Tue 29 Jul 2008, 10:31 Trainer Pete said...

RE: excel function

Hi Daniela,

Thank your for your post, The IF function is used to determine the state of a condition, i.e.: if it is TRUE or FALSE, dependant on the answer then further actions can be undertaken; so if we consider the formula =IF(A1>=100,A1*2,0) which translated would be; Is A1 greater than or equal to 100, if it is (TRUE) then multiply the value of A1 by 2, if it is not, (FALSE) then do nothing (0). Taking this further, you can nest up to 7 IF statements, and also use other formula in the IF statement, substituted for either of the statements (TRUE or FALSE). For example: =IF(A1>100,A1*2,IF(A1>75,A1*3,IF(A1>50,A1*4,0)))

I hope that helps, regards Pete

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Excel function

Excel function

RE: excel function

Excel articles

Excel tip:

Generating Random Numbers