Set a minimum value

[Geoffo123]

Guys,
Is it possible to use a formula e.g cell C7 '=(C4*C5)/3' but have cell with the answer remain no lower than a minimum amount?

This is to calculate work hours based on a job size, however, if I input (C4) as a 1 (1 Tonne), I get an answer of 0 in cell C7.

Not sure if I should be using another formula to cover this

Thank you in advance for any help

 

[Scott Huish]

You didn't say what your minimum amount was, but say you didn't want any value lower than 10:
=MAX(10,(C4*C5)/3)

 

[Eric W]

What do you have in C5? Unless you have 0 in C5, you should get something in C7. You could use something like:

=MAX(1,(C4*C5)/3)

to set a lower value of 1, no matter what's in C4 and C5. You could use something like:

=ROUNDUP((C4*C5)/3,0)

to make sure your formula rounds up to the next whole number.

 

[Geoffo123]

Thanks guys, absolute champions