im looking for a formula where a minimum will be returned, if the cells
aren't 0 or blank.
for example:
Spans# 1 - 120", #2 - 80", #3 - 0"
Anti-buckling clip spacing = 24"

so, we have 2 spans, with anti-buckling clips at 24" on centre.
I would like the cell containing the formula to equal 24.

Lets now say we don't have any anti-buckling clips, and the cell is left
blank.
Spans# 1 - 120", #2 - 80", #3 - 0"
Anti-buckling clip spacing =

The cell should read: 80

Any ideas? im trying to work with a nested if statement inside a =min()
function, but im not sure how to return a 'nothing here, move on' line.
Thanks!