Help with IF, THEN

L_Mallery

I want a calculation to run if a cell value is within a range.

IF Cell X is between 1-4, THEN sum(cellZ, cellP, cellH)

How do I write this?

Paul Newcome

You would use an IF/AND combo.

=IF(AND([Column name]@row>= 1, [Column name]@row<= 4), SUM(............))

Paul Newcome

You would use an IF/AND combo.

=IF(AND([Column name]@row>= 1, [Column name]@row<= 4), SUM(............))

L_Mallery

Thank you!

Paul Newcome

Happy to help. 👍️