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
 
G

Guest

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) ? 1
Is there a way to shorten this? 4
for each in a range 1
Check a range to see if a value exists in it 5
How to update a range of cells if cell value is equal to... 6
Value of a cell in a range if color is yellow 1
VBA reset cell value if greater then 0 8
Supressing a #VALUE! error returned? 3

Top