range checking

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

hi
We have a spreadsheet with a range of values from A1 to Z1
which contain numeric values ranging from 1 to 5
is it posible to check the range for a minus value
if a minus value found then make the cell AA1 = to minus value
this would need to be a formula if posible


kevin
 
One way,
Enter in AA1:

=IF(MIN(A1:Z1)<0,MIN(A1:Z1),"No Neg.")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

hi
We have a spreadsheet with a range of values from A1 to Z1
which contain numeric values ranging from 1 to 5
is it posible to check the range for a minus value
if a minus value found then make the cell AA1 = to minus value
this would need to be a formula if posible


kevin
 
kevin carter said:
hi
We have a spreadsheet with a range of values from A1 to Z1
which contain numeric values ranging from 1 to 5
is it posible to check the range for a minus value
if a minus value found then make the cell AA1 = to minus value
this would need to be a formula if posible

kevin
Click to expand...

Your question isn't very clear. If A1:Z1 contain numbers in the range 1 to
5, there can't be any negative ones! Do you mean the numbers are in the
range 1 to 5 or -1 to -5? Can there ever be only one negative number? If
there can be more than one, which do you want? What should AA1 have if there
is no negative number?

As an example, this formula will return the most negative number if there is
one or more, or zero if not:
=IF(MIN(A1:Z1)<0,MIN(A1:Z1),0)
 
Back
Top