"if(and)" function help

[charlotte89]

Hi there, I am struggling to get a nested if(and) formula to work in my spreadsheet.
I would like to report the content in column D if the following conditions are met:
pH>4.5, AND pH<7.5, AND flow>0, AND Al>0.055. I have used the following formula:

=IF(AND(C2>7.5,C2<4.5,B2>0,D2>0.055),D2,FALSE)

While it is not throwing up an error code, it is not returning any value when all 4 conditions are met - see row 36.
Can anybody please offer some help on this issue?

Thank you

 

[dreid1011]

Your conditions for col C look backwards.. at least as it shows in the formula bar anyway, that won't work. The number can't be both greater than 7.5 and less than 4.5 at the same time. Maybe your > and < are backwards?

 

[Michael M]

I agree with @dreid1011
I think you need

=IF(AND(C2<7.5,C2>4.5,B2>0,D2>0.055),D2,FALSE)

 

[Alex Blakenburg]

@charlotte89 I'm a bit confused. The text indicates you want the True condition to be when the Ph is between 4.5-7.5 and @Michael M and @dreid1011 are reading it that way but your formula and example suggest that you actually want it outside of those parameters, which would translate to something like this:

=IF(AND(OR(C2>7.5,C2<4.5),B2>0,D2>0.055),D2,FALSE)