IF Functions

Hi - can someone tell me how to set up an 'IF' statement so that if one letter or word is typed in a given cell one calculation is carried out and if another letter / word is typed into that cell another calculation is carried out?

Dan

It depends how many IF's you have but basically you can nest up to seven in versions before 2007 after that is a much large number but if I use much more than two or three I tend to look to set up a table and use a VLOOKUP.

The theory is..

=IF(A1="This Word",B1+C1,D1+E1)

In this case if the cell A1 contains This Word it will add B1 and C1 together and if not it will add D1 and E1 together. If you want to use multiple If's start the next IF where D1+E1 is and set a condition and True/False calculation to make.

Hi Dan,

An alternative is to use the Choose function, this allows you to choose an option, which could be a formula depending on an index number

=Choose(A5, A1+B1, A1/B1, A1*B1) - so if you had 1 in A5, it will perform the first calculation, if you have 2 in A5, the second etc.

Hope this helps

Many thanks Nick - your advice worked a treat!

Regards,

Dan