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(A2:D2)=0,E2=0),"Error","OK")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David" wrote:
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


--
David