Value used in the formula is of the wrong data set.

[gperez1127]

I have the following formula: =IF(AP32*AQ32*AR32*AS32>0,"Y","N")

I am creating a spreadsheet that gives results on a monthly basis and on a Quarterly basis. Under the quarterly basis I am getting the valued used error only on the columns that are blank. Not sure why this is happening only under the Quarterly and not monthly. It needs to return a Y if all the columns have numbers, if not then it needs to return an N


Not sure where the issue is. Help Thank you

 

[iggydarsa]

would something like this work?
=IF(AND(ISNUMBER(A1), ISNUMBER(A2),...), "Y", "N")

 

[inactiveuserps07]

Try this:

=IF(ISNA(MATCH("",AP32:AS32,0)),"Y","N")

or this:

=IF(COUNTIF(AP32:AS32,">0")=4,"Y","N")

 

[gperez1127]

Thank you the =IF(COUNTIF(AP32:AS32,">0")=4,"Y","N") is the one that worked. I appreciate the help.

 

[inactiveuserps07]

@gperez1127, glad you found one that fit your specific needs.