Hello,
I have a formula with muliple nested "If" statements that works perfect in 2010. However, the file will also be used with 2003 and thats a problem. Apparently 2003 does not allow the count that 2010 does. I'm sure there is something much better but I'm not sure what it is. Thanks so much for your help. Below is the actual formula I use.
<colgroup><col style="width: 48pt;" width="64"> <tbody>
</tbody>
I have a formula with muliple nested "If" statements that works perfect in 2010. However, the file will also be used with 2003 and thats a problem. Apparently 2003 does not allow the count that 2010 does. I'm sure there is something much better but I'm not sure what it is. Thanks so much for your help. Below is the actual formula I use.
=IF(B519=Inv!$A$31,Inv!$B$31,IF(B519=Inv!$A$32,Inv!$B$32,IF(B519=Inv!$A$33,Inv!$B$33,IF(B519=Inv!$A$34,Inv!$B$34,IF(B519=Inv!$A$35,Inv!$B$35,IF(B519=Inv!$A$36,Inv!$B$36,IF(B519=Inv!$A$37,Inv!$B$37,IF(B519=Inv!$A$38,Inv!$B$38,IF(B519=Inv!$A$39,Inv!$B$39,IF(B519=Inv!$A$40,Inv!$B$40,IF(B519=Inv!$A$41,Inv!$B$41,IF(B519=Inv!$A$42,Inv!$B$42,IF(B519=Inv!$A$43,Inv!$B$43,IF(B519=Inv!$A$44,Inv!$B$44,IF(B519=Inv!$A$45,Inv!$B$45,IF(B519=Inv!$A$46,Inv!$B$46,IF(B519=Inv!$A$47,Inv!$B$47,IF(B519=Inv!$A$48,Inv!$B$48,IF(B519=Inv!$A$49,Inv!$B$49,IF(B519=Inv!$A$50,Inv!$B$50,IF(B519=Inv!$A$51,Inv!$B$51,IF(B519=Inv!$A$52,Inv!$B$52,IF(B519=Inv!$A$53,Inv!$B$53,IF(B519=Inv!$A$54,Inv!$B$54,IF(B519=Inv!$A$55,Inv!$B$55,""))))))))))))))))))))))))) |
<colgroup><col style="width: 48pt;" width="64"> <tbody>
</tbody>