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 |
#2
|
|||
|
|||
If Q13:Q76 are empty, or contain text, they should be looked over by the min
function ,but you can try =MIN(IF(ISNUMBER(Q1:Q76),Q1:Q76)) entered with control shift enter to see if that does what you want. "Tip Rabbit Rabbit" <Tip Rabbit wrote in message ... 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 |
Reply |
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) |