| Problems with Nested IF and Arrayformula | Koch8 | 7/5/12 9:18 PM | im having problems with a formula that work fine without the arrayformula This works Fine=IF(A3<>"",IF(TODAY()<=A3,1,IF(AND(TODAY()>A3,TODAY()<=A3+30),.8,IF(AND(TODAY()>A3+30,TODAY()<A3+60),.5,.1))),"-") This Dont:=ARRAYFORMULA(IF(A2:A<>"",IF(TODAY( |
| Re: Problems with Nested IF and Arrayformula | Yogi Anand | 7/7/12 11:31 AM | Hi Koch8: I want to make sure I clearly understand your criteria ... so 1) how about if you explain your 3 requirements in layman's terms2) tell us what you are trying to accomplish3) show us what is your expected result in all 3 cases along with |