hi im doign some work for my IT class and im stuck on a formula
basiclaly im trying to do an if statement with the IF TRUE calculating another fomula basically 2 formulas in 1 ..sorry if it soudns hard its hard to explain... ill try and simplify
IF THIS+THIS+THIS+THIS+THIS=0 IF TRUE THEN =LOOKUPTABLE BLA BLA BLA
IF FALSE THEN =THIS+THIS+THIS+THIS

the formula below is what i have actually created... im thinking with if statements you can only put a word for the true or false and nto a formula

=IF(D12+D13+D14+D15+D16+D17=0,"=LOOKUP(C7,'Employee Table'!A5:A10,'Employee Table'!C5:C10)",D12:D17)

thanx for the help guys

The way I read your formulas is that If the statememt D12+D13 etc evaluates to Zero then the lookup is performed otherwise nothing is done as there is no function if the the IF expresion is false.

D12,D13 etc had better contain a lot of negative number for there to be any chance of the expression being true.

Here is one of my IF formulas to give you an idea of what is needed.

C9=IF(C7 < C8,0,IF( C7-C8> D16,D16,C7-C8))

In plain English:

if C7 < C8 then C9 = 0 ESLE IF C7-C8 > D16 then C9 = D16 else C9 = C7-C8

FYI this formula calculates income taxable at 22% once the basic allowance and 10% band has been taken care of. Anything left after this is taxed at %40.

Stuart

first test ur condition by having a formula =if(D1+....=0;"A";"B") to see what result u have to ur condition.
I suspect ur problem is in ur vlookup: what do u bring if u don't find ur item ? try to replace ur d12:d17; by "false"... and see.Check ur vlookup formula by putting it (without if statement) in a cell point on it and launch the function icon ( looks like "fx" button). U'll see the result in regard of each argument.