Forum Discussion
Listing IF formulas
I'm hoping someone out there can help..? I'm trying to list a number of IF formulas in one cell. If I do just the first one by itself, the formula works and I get the correct answer. However, when I...
Every Excel manual I've ever read warns against formulas like this. They're next to impossible to understand. So far as I know nobody has actually ended their life over such frustrations, and I surely hope you won't be the first.
But the solution would be to break the conditions apart and deal with them in multiple columns, perhaps hiding some of those columns if you don't need the intermediate results. Nesting functions like this is fun when it works, but--as you've discovered--not fun in the extreme when they don't work.
But the solution would be to break the conditions apart and deal with them in multiple columns, perhaps hiding some of those columns if you don't need the intermediate results. Nesting functions like this is fun when it works, but--as you've discovered--not fun in the extreme when they don't work.
Thank you mathetes
Yes, as I was creating this string I was beginning to realise that it wasn't the best way to do things. But I'm going on hols on Monday and was hoping to make this work before then - its just a small part of what I need to complete so I was keen just to find out the particular issue in what I have done.