Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional minimum formula
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Minimum formula | Excel Worksheet Functions | |||
MINIMUM - CONDITIONAL | Excel Discussion (Misc queries) | |||
Looking for a conditional minimum value | Excel Discussion (Misc queries) | |||
conditional minimum value of various cells? | Excel Worksheet Functions | |||
Conditional format of minimum number | Excel Worksheet Functions |