Probably to many IF statements

[bander1]

=IF(C11=“Fairway”,IF(C12=“3i (225)”,IF(C13=“Full”,IF(C14=“100%”,C8/B45))))

Trying to get the reset of C8/B45 if the other cells have the correct information of C11=Fairway, C12=3i (225),C13=Full and C14=100%

But just get a ‘FALSE’ message appearing, its probably to many IF statements in the equation but i’m reaching the limit of my spreadsheet knowledge to fix it, hope you can help.

Cells C11 to C14 are text from a selection list, e.g. C11 has the option of Fairway or Tee. Any changes would result in cell C8 being divided by a different number.

I’ve attached the file here:

Shot Calc.ods

[Hrbrgr]

Trying to get the reset of C8/B45

I do not understand that. What is in the cells?

Try to test the IF statements individually. Are you sure that all cells C11 to C14 are formatted as text?

Better still, if you upload the file here.
Edit your initial question and click on the “Attachment” icon.

[ve3oat]

Like @Hrbrgr, I don’t understand what you are trying to do. You seem to have a hierarchy of IF tests (which I don’t understand). On the assumption that you had in mind instead a simple series of IF tests, it might help you to know that tests can be combined into one IF test by using the AND logical function. (Not sure if it works with OR.)
The general form is =IF(test,then,else)

which can be expanded to =IF((test1)AND(test2)AND(test3)AND(test4),then,else)

Hope this helps.

[schiavinatto]

Hi, @bander1, see pictures

In C15, set the formula:

=IF(AND(C11="Fairway";C12="3i (225)";C13="Full";C14="100%");C8/B45;"xxx")

xxx = when negative

---

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball to the left of the answer, to finish the question.

[bander1]

Thank you very much everyone for responding with the answer and all the comments.

[mikekaganski]

The problem is that in C14, you have not a text “100%”, but a number 1 (=100%). So, simply modifying your formula to

=IF(C11="Fairway";IF(C12="3i (225)";IF(C13="Full";IF(C14=100%;C8/B45))))

will fix the issue (note that I just removed the double quotes around 100%).

Or do as suggested by @ve3oat:

=IF(AND(C11="Fairway";C12="3i (225)";C13="Full";C14=100%);C8/B45)

[ve3oat]

Thank you @mikekaganski. I didn’t know that the several tests could be collected into one AND() expression. Very neat that way.

[mikekaganski]

Actually the test AND test AND test AND ... syntax is compatibility-only, and is deprecated - I had been told by @erAck about that when suggested that syntax to someone.

[ve3oat]

Nice! And thanks for passing it on.