Software

Ask something
Discussion Locked

emergancy pls

0 helpful
5 replies

by imranmcse

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
HI friends, I have a worksheet created in excel I am implementing a formula in which I used if nested conditions I want to use more then 8 nested if conditions in this formula but excel is not accepting this one, so kindly please help me that how isthis possible that I can use many nested conditions in one cell formula.

5 replies

by brian

I have an idea that works with certain situations.
You can make an initial formula that splits this formula in 2. For instance if you are trying to do a formula to provide different results for 10 conditions, such as if the number is 1,2,3,4,5,6,7,8,9,or 10. You could put the formula for numbers 1-5 in one remote cell and 6-10 in another cell. In the cell where you currently have the formula you would direct the result to either remote cell based on if the number is between 1&5 or between 6&10. This is the only way I know of to do this but there may be others. I am just sharing my idea, hope it helps.
Good Luck!

This discussion is closed to new replies.