I have a formula with may IF statements and* I need this to work in Excel 2000. The issue is I have this formula and it works fine in Excel 2000
*
WORKS
*When I try to add just 1 more If to this (more than 8) It will give me an error in Excel 2000.*
*
DOESN'T WORK IN EXCEL 2000
*
=IF(V15="#'S",$A$355,IF(V15="INV",$A$354,IF(V15="OP INV",$A$355IF,IF(V15="OP",$A$355,IF(V15="REQ OP",$A$355,IF(V15="MID",$A$356,IF(V15="REQ MID",$A$356,IF(V15="CL",$A$357,IF(V15="REQ CL",$A$357,""))))))))
*
Does anyone know of a way to write the 2nd formula having 8 or more IF's?
Bookmarks