How might one say the following in VBA? Its suppose to be for all 12 months but Excel 2007 told me that I "exceeded the Nesting Levels".
What parameters need to be created to do it?
=IF(ISNUMBER(FIND(" JAN ",D27)),"JAN",IF(ISNUMBER(FIND(" FEB ",D27)),"FEB",IF(ISNUMBER(FIND(" MAR ",D27)),"MAR",IF(ISNUMBER(FIND(" APR ",D27)),"APR",IF(ISNUMBER(FIND(" MAY ",D27)),"MAY",IF(ISNUMBER(FIND(" JUN ",D27)),"JUN"," "))))))
Can you help please?
Thank you,
K
What parameters need to be created to do it?
=IF(ISNUMBER(FIND(" JAN ",D27)),"JAN",IF(ISNUMBER(FIND(" FEB ",D27)),"FEB",IF(ISNUMBER(FIND(" MAR ",D27)),"MAR",IF(ISNUMBER(FIND(" APR ",D27)),"APR",IF(ISNUMBER(FIND(" MAY ",D27)),"MAY",IF(ISNUMBER(FIND(" JUN ",D27)),"JUN"," "))))))
Can you help please?
Thank you,
K