Thread: Use criteria for values in range for small function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
like2hike
 
Posts: n/a
Default Use criteria for values in range for small function
I have a range (a1:a5) with values such as:

0, 5, 25, 0, 3

I want to pick the smallest value other than zero because I will use that
number to divide by and do not want the #DIV/0! error. However, the initial
state of the spreadsheet will have a range of:

0,0,0,0,0,0

How can I have the spreadsheet display some text until data is entered into
the spreadsheet?
Reply With QuoteReply With Quote