#VALUE! for Nested IF Statement (1 Viewer)

[MayoRR5]

Hi guys, scoured the web but can't see the reason for getting the VALUE error for this. Could be something simple but I am really not seeing it :banghead:

=IF(AND(K2315:K2319<1,K2328:K2335<1,K2347:K2357<1,K2366:K2373<1,K2393:K2409<1,K2416:K2421<1,K2437:K2449<1,K2455:K2459<1,K2467:K2473<1,K2481:K2487<1,K2507:K2523<1,K2538:K2549<1,K2569:K2585<1),1,0)

These cells are being selected so that if they have a value entered for quantity I want to flag it, so they are aware that the product they have selected is "unusual"

Thanks for the help.
Shaun

 

[namliam]

You cannot simply do a "Range"<1, I can guarantee you will not get the answer you are expecting....

Perhaps you can post a sample of what you are trying to do and perhaps a bit more detail on what you are trying to do, your explenation is schetchy at best

 

[MayoRR5]

Hi namliam, sorry I wasn't clearer.

I have a worksheet that lists around 30,000 line items and some of these are considered to be unusual.

I have a header section at the top of the worksheet and I would like a message to appear here if a quantity were to be assigned to the items. (see screenshot)

I thought an IF statement would do the trick and the Data Validation only shows a message beside the cell when its selected which I have already applied but is not as "in your face" as I would like.

So, if someone chooses an unusual item from the list, the top of the page should state this.

Shaun

 

[namliam]

If its quatities, try something like:
=IF(Sum(K2315:K2319,K2328:K2335,K2347:K2357)<1,1,0)

 

[MayoRR5]

SUM!!!!! I knew there was another way to do that simply. Thanks namliam!!!!