Mutiple IF conditions
Posted by Oli on December 20, 2001 10:26 AM
I need help with my I.T coursework!
How can i have multiple "IF" conditions?
This is the formula i have so far:
However i also want to include the formula:
and many more If conditions in the same cell, ideally it would be best if i could create some kind of a relationship between cell "C4" and what is displayed in cell C3, there is a relationship of +3 between what cell C4 equals and what i want to display in cell C3.
If there is no way to make a formula to do this i could still put in loads of IF conditions however i do not know how to do more than 1 in the same cell :(