Check if any value in a range is equal to 0

D

Daz

Hi all.

Quick question.

I have several cells - i.e M8 : M12. These cells can contain integers 0
to 10.

I want to be able to design a formula that says - if any cell in the
range M8:M12 contains a 0 then change the value of M13 to say
"INVALID", otherwise it is "VALID".

I'm having a bit of trouble designing this - tried nest IF statements
and formula.

Suggestions appreciated.

Regards
Daz
 
J

JMB

If you are open to a suggestion, I think you could shorten it to
=IF(OR(M8:M12=0),"Invalid","Valid")

array entered with Cntrl+Shift+Enter (or you get #VALUE).
 
D

Daz

Thanks for these very helpful suggestions.

If you are open to a suggestion, I think you could shorten it to
=IF(OR(M8:M12=0),"Invalid","Valid")

array entered with Cntrl+Shift+Enter (or you get #VALUE).
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula function for ignoring cells/results equal to 0 (zero) ? 2
Code to Assist with Nested Function, Also Using ISERROR 2
for each in a range 1
Check a range to see if a value exists in it 5
Check for >0, then offset down 310, left 4, Check for = 0 6
Copying sheet and generating name of new sheet 10
Is there a way to shorten this? 4
Double click fails to run the code, just selects the cell 12

Top