G
Guest
I'm doing something wrong and can't figure it out. Can anybody help me?
Here’s what I want: If user enter value in cells A1 through A5, I want cell
A6 to return “Must be filled inâ€
Here’s the formula I put in A6: =IF(A1>0,"Must be filled in!","") and it
works, but only for one reference cell.
What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A5>0,"Must
be filled in!",""). And I get a #VALUE! Error in A6.
Help!
Here’s what I want: If user enter value in cells A1 through A5, I want cell
A6 to return “Must be filled inâ€
Here’s the formula I put in A6: =IF(A1>0,"Must be filled in!","") and it
works, but only for one reference cell.
What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A5>0,"Must
be filled in!",""). And I get a #VALUE! Error in A6.
Help!