IF Function that recognizes a range

[missmea2005]

I have an IF function that I want to give a result if one or more of the numbers in a range are less than 0

Please Login or Register  to view this content.

this is the code i'm using, but i'm getting an error

[Jakobshavn]

=IF(MIN(B7:B28)<0, Not Entered","Approved and Requested")

[Pete_UK]

Try it this way:

Please Login or Register  to view this content.

Hope this helps.

Pete

[Andrew-R]

Try:

=IF(OR(B7:B28<0),"Not Entered","Approved and Requested")

Confirmed with Ctrl-Shift-Enter, not just enter.

Or:

=IF(MIN(B7:B28)<0,"Not Entered","Approved and Requested")

Confirmed with plain old Enter.

[missmea2005]

Thanks. these worked, but I's like if one or more of the numbers in the series is missing, then it will say not entered.

[Jakobshavn]

Then try:

=IF(OR(MIN(B7:B28)<0,COUNTBLANK(B7:B28)>0), "Not Entered","Approved and Requested")

[Andrew-R]

Try:

=IF(COUNTBLANK(B7:B28)>0,"Not Entered","Approved and Requested")

[missmea2005]

Thanks @Jakobshavn and @Andrew-R worked like a charm!!!