| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Min Formulas in #VALUE! Cells
I need a min formula that will give me the minimal value of the cells q1:q76.
Cells q1:q12 have vlaues in them, but q13:q76 do not have values because the information has not been entered, thus leaving the cells #VALUE!. This leaves my =MIN(Q1:Q76) at #VALUE! Please offer any help. Jenn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
| loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions | |||
| Correct formulas in cells, have to retype to work | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
Threaded Mode
