Hi everyone,
I'm trying to write an excel formula using columns that have blanks and N/A values. Here's the formula: =IF(AND(SUM(AX3:AX12)=0,Calc!AL13<0.33,Calc!AL13<Calc!AL4),1,"")
It obviously doesn't work because of the error values, so I tried this formula to account for that : =IF(AND(SUM(AX3:AX12)=0,Calc!AL13<0.33,Calc!AL13<Calc!AL4),1,""),IF(ISERROR(IF(AND(SUM(AX3:AX12)=0,Calc!AL13<0.33,Calc!AL13<Calc!AL4),1,"")),IF(AND(SUM(AX3:AX12)=0,Calc!AL13<0.33,Calc!AL13<Calc!AL4),1,""),1)
But I'm getting a #VALUE error. I feel like I've tried everything! Can someone help me solve this?
Bookmarks