There must be a better way to accomplish what you are attempting.

This usually means that youre attempting something too complex with a formula.

Since then, the formula length limit has been 8,192 characters, and this formula is well below that.

Just double check for each if(a,b,c) and and(a,b,c) to have enough brackets, dataarguments and comma.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel if-statement formulas or ask your own question.

For a better experience, please enable JavaScript in your browser before proceeding.

Now generally this isnt a problem, but apparently PCs have a limit on how long the formula can be.

Is there anyway to overcome this I really need this formula to work.

BTW, Im not familar with Excel on the Mac, but I dont know what the s are for in your formula.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Excel For Mac Formula Too Long Message