IF function

Hi Dympna, Thank you for the post and welcome to the forum, in answer to your question, Linking or Nesting IF formulas can be accomplished like this:
In Excel you can nest up to 7 functions, the IF function is a 'What If' operation, which checks a particular item, if the condition is True it will return one result, if False another. When we create a nested IF, it is usual that we know the answer to the True portion but are searching for the result from the False portion.
So if the syntax for a single IF is: =IF(arguement,True,False) then the syntax for a nested IF will be =IF(arguement,True,IF(arguement,True,IF(arguement,True,False))) remembering to close as many parenthesis as you have opened. To look at this as an actual formula we may be considering if cell A1 is between a particular set of values and applying a calculation dependant upon the value; so in cell B1 we could create the formula; =IF(A1>100,A1*10,IF(A1>75,A1*7.5,IF(A1>50,A1*5,0))) which would then decide if A1 was greater than the value given in this case 100,75 or 50 and in each case would multiply the value by 10,7.5 or 5; dependant upon the value found, if however the value was below 50 then nothing would be undertaken. I hope that helps, best regards Pete.