I want to look at different criteria depending on the document type listed in my spreadsheet. I use this formula:
=IF(OR(A12={65,7},D12-C12>2),
IF(G12<=4,1,0)),
IF(OR(A12={17,8}),
IF(G12<=1,1,0),
IF(G12<=3,1,0))
So, if it's a 65 or 7 AND D12-C12 is >2 I want a 1 or 0 depending on the value in G12.
For 17's and 8's the criteria is looking to G12...if less than or = to 1 it's a one, 0 if false
If the document is not a 65,7,17 or 8 then it will use "3" in G12 as the criteria for true/fale (1,0).
When I enter that formula (without line breaks) I get a #value error. I made sure everything was a number. Also, if I take this out:
,IF(OR(A11={17,8}),IF(G11<=1,1,0),IF(G11<=3,1,0))
the #value error goes away. Any thoughts???
Bookmarks