| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for a cell which is blank returns populated cell
I am writing a formula to return a minimum value from an array of cells, but
if the cells are blank it does not return any value, how can I rectify this, shown is my formula. =IF(AT12=0,MIN(M12,AT12,AP12)) M and AT are populated and when I take out AP it returns the lower value, but when I enter AP which is a formula returning no answer, my other formula returns a blank cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Array formula returns blank in the cell where it is entered | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Threaded Mode
