Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to return "0" based on another cell
I am using =min(a1:a10,b1:b10)to return the min number in two fields, however
i want the cell to remain blank or return "0" if another cell is blank or zero. Can anbody help? |
#2
|
|||
|
|||
Do you mean
=IF(X1="","",MIN(A1:A10,B1:B10)) -- HTH RP (remove nothere from the email address if mailing direct) "CM" wrote in message ... I am using =min(a1:a10,b1:b10)to return the min number in two fields, however i want the cell to remain blank or return "0" if another cell is blank or zero. Can anbody help? |
#3
|
|||
|
|||
Would this help? I was looking at your part that says...
"...if another cell is blank or zero."... =IF(OR(ISBLANK(C1),C1=0),"",MIN(A1:B10)) HTH -- Dana DeLouis Win XP & Office 2003 "CM" wrote in message ... I am using =min(a1:a10,b1:b10)to return the min number in two fields, however i want the cell to remain blank or return "0" if another cell is blank or zero. Can anbody help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |