New Contributor

# Formulas

How do I write a formula to give me a total in column H (which at the moment can be -1 and then causes my total of the column to be wrong by the number of -1s in that column please.

I just cannot get something right in the arguments

2 Replies

# Re: Formulas

For example

=MAX(SUM(C2,E2)-1,0)

# Re: Formulas

Spot on - just what I needed apart from 2 paracetamol !