Hello. I hope you will be able to help me… I need to incorporate a couple of IFs and no matter how I try - I do not get values I need. If I separate the two statements, I get the right value but if I try to combine these together, something does not work. I need:
If P3 is >=b5 but E5:O5 is less than A5, then give me C5, otherwise, it is 0. I used this formulae:
=IF(AND(P3>=B5,E5:O5<A5),C5,0)
I have attached my workings, your advice what I do wrong is greatly appreciated.
Hi Monika,
Welcome to our forum!
You can use this formula in cell P5:
=IF(AND(P3>=$B$5, SUM($E$5:O5)<$A$5),$C$5,0)
And copy to columns F:O
Mynda
I'm eagerly welcoming you here!
Thank you very much for accepting me to this forum and for welcoming messages.
I cannot believe, that just by locking the cells my puzzle got sorted! Thank you!
And adding the SUM to the condition 😉
