Search for 2 true arguments and return true or false

[David]

I'm sure that what I'm after is easy - anyway here is the problem: -

I have 4 rows which contain values and a separate column which shows a
corresponding value for the number of months. If there are values in the 4
rows then there should be a corresponding value in the months column, so if
it shows zero there is an error in the spreadsheet. Because there are loads
of rows this would be a good check to validate the data in the spreadsheet.

Conditional formatting could be an option, although I'm not sure how to do
it or I was thinking of a function like the one below (but one that works): -

If there are values in columns A through to D and column E is 0 then show
ERROR otherwise show OK.

Hopefully the above clearly explains what I'm trying to achieve.

Thanks

 

[Max]

If there are values in columns A through to D and column E is 0 then show

ERROR otherwise show OK.

Perhaps in F2, copied down:
=IF(AND(COUNTBLANK(A22)=0,E2=0),"Error","OK")

 

[Max]

Perhaps in F2, copied down:

=IF(AND(COUNTBLANK(A22)=0,E2=0),"Error","OK")

Better to make it in F2 as:
=IF(AND(COUNTBLANK(A22)=0,E2=0, E2<>""),"Error","OK")

(added test: E2<>"")

 

[davesexcel]

try this adjust to your needs

=IF(COUNTBLANK(A1:E1),"Error",NOW())

now() shows todays date, you can change it to what ever you requir