CODEWITHSUNDEEP
excelexcel-formula
jallington
jallington

Reputation: 181

How to check if a range of cells all have a value?

Firstly, I am learning excel and am still a novice so I apologize that I do not know the best function to start the formula, but I believe it is a IF or SEARCH.

What I want to accomplish: If a range of ALL of a value (always a number or percent) then return True, if even one cell in the range is blank then return False.

So if i were to write the formula verbally I would say:

If range A1:A5 **all** contain a value of any kind, return true, **if all do not** contain a value, return false.

Upvotes: 0

Views: 1330

Answers (2)

user4039065
user4039065

Reputation:

Try this standard formula for 'a value of any kind',

=counta(a1:a5)=5

Alternate,

=not(countblank(a1:a5))

To check specifically for five numbers,

=count(a1:a5)=5

Upvotes: 3

pnuts
pnuts

Reputation: 59450

Please try something like:

=COUNTBLANK(A3:G3)=0

Though this will accept text instead of a number or percentage.

Upvotes: 2

Related Questions