formula to return a spcified value if a set of criteria meets con.

[Georgia at Nexstar]

I have mulitple columns of data to evaluate. I need to be able to add a
column to the end where in each row I can enter a set of criteria that will
return a specified value.

For example:
If cells A1 thru F1 are null/blank (contain no data) return the value
"current month"
If cell A1 is not null (contains any type of data) return value "prior month"

 

[Frank Kabel]

Hi
do you mean
=IF(A1<>"","prior month",IF(COUNTA(A1:F1)=0,"current month","not
defined"))

--
Regards
Frank Kabel
Frankfurt, Germany

"Georgia at Nexstar" <Georgia at [email protected]>
schrieb im Newsbeitrag

I have mulitple columns of data to evaluate. I need to be able to add a
column to the end where in each row I can enter a set of criteria that will
return a specified value.

For example:
If cells A1 thru F1 are null/blank (contain no data) return the value
"current month"
If cell A1 is not null (contains any type of data) return value

"prior month"