Formula for IF, AND, OR

[rlowry]

Cell B12 7.8 Cell C12 7.4 Cell D12 7.7 Cell E12 7.5

Cell B13 60 Cell C13 50 Cell D13 80 Cell E13 60

IF B12>=D12,(if B12 is equal to or greater than 7.7)
AND IF B13 >E13 <D13 (and if B13 is between 60 and 80)
Then return'pH-Alk Calc'!H49
else "" (blank)

Can't figure this out.
Thank you.

[6StringJazzer]

Try

Please Login or Register  to view this content.