Forum Discussion
Solved
nested if & all statement returning the wrong values
I am using windows 10 with an excel version MS office Home and Student 2016. When I use the "if" statement with an "AND" statement, it always results in 0 (when some of the TRUE results result in dif...
ryanlwaltman Quickly replicated the relevant parts of your schedule and the formula from your original post returns 150 from O22 and down. See attached.
Edit: didn't notice your comment on circular references until I posted this message.
Riny_van_Eekelen Yes, that is the correct interpretation and intention of the formula. However, once at O22, the cell does not become 150 but rather stays 0. When I evaluate the formula, this is what I see:
The formula should end at step 9, returning a value of 150. However, it continues to the false section and then returns a 0 for some reason. I'm not sure why the formula is doing this.
ryanlwaltman Quickly replicated the relevant parts of your schedule and the formula from your original post returns 150 from O22 and down. See attached.
Edit: didn't notice your comment on circular references until I posted this message.