help with nesting if statements? or

Try something like:

Formula:

Please Login or Register  to view this content.

Not looked at it yet but columns N and O appear to be redundant in relation to the outcome of the other combinations. That's why I took them out and put something in place for them both being NOT blank. Perhaps it should NOT/OR rather than NOT/AND

Sorry, I will try and explain...

the idea is that when an x is selected in one of the 2 columns/cells (L,M,) ..it triggers the size to change by 1 in the R column/cell , if there is no x it remains the same. the N and O don,t affect the R column/Cell but will affect the S column/cell in the same way when I add the formula to it, but it wont affect the L or M in the same fashion....


I will try to add the suggested code...

Thanks to you both for your suggestions..

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

I think you may have missed a trick here as davsth's solution is much neater. I was looking at the problem again and came to exactly the conclusion that davsth did ... but he beat me to it in post #5. Basically, you subtract 1 whenever there is an "X" in columns L:M, so it makes sense to just count the number of Xs. No nested IF required, especially as you are no longer taking into account the other columns.

You're welcome.


All credit to davsth