General discussion

Locked

emergancy pls

By imranmcse ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

emergancy pls

by DKlippert In reply to emergancy pls

Chip Pearson has a work around on his site:

http://www.cpearson.com/excel/nested.htm

(There are no spaces in the URL)

Collapse -

emergancy pls

by imranmcse In reply to emergancy pls

Poster rated this answer

Collapse -

emergancy pls

by brian In reply to emergancy pls

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!

Collapse -

emergancy pls

by imranmcse In reply to emergancy pls

Poster rated this answer

Collapse -

emergancy pls

by imranmcse In reply to emergancy pls

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums