I see some if functions here and there, but without knowing which ones you want to have precedence I can't really put them together for you.
Anytime I need to put together a large group of "if"s, I do them one at a time, a-like-a-so
enter your first step into a cell
=if(a2>2,"Greater than 2","next step"
in the cell under it, the next step
=if(a2=2,"Equals 2","next step"
and so on and so forth
=if(a2<2,"Less than 2","End code"
That way you can test each section while still only changing your initial data, also works if they're dependant upon eachother ( The code would simply refer to the cell above it for it's criteria ). When you want to conglomerate them all, start at the bottom, (I'd recommend making a copy of them while seperated for future use), anyways, start at the bottom, and work your way up, replacing "Next step" with the formula from the line below it, without the = of course ( If the cells are dependant upon eachother, you'd replace any part of the code which had say.. A2, with the formula in A2) . Add one more bracket on the end for each IF you add, and there you have it - An insanely complex if statement which is completely indicipherable. But functional.
p.s.
I'd REALLY recommend keeping a copy of the broken down versions for future use, saves a lot of trouble if criteria changes.
Bookmarks