Choose Office Button-Save As-Excel Workbook
That will save in XLSX format (default for 2007)

Or Choose Office Button-Save As
then in Save as Type you will see Excel Workbook (.xlsx)



"bbal20" wrote:

How do I save in the XLSX format. It doesn't show as an option in the drop
down menu for the "save type as"?
--
Thank you for your help and support


"Sheeloo" wrote:

Your workbook is probably still in XLS format... Excel 2007 imposes the
limits of 2003 in that format so that it can be kept compatible.

Save it as XLSX (2007 format) and it will allow you more than 7 IFs...

"bbal20" wrote:

I was under the impression that excel 2007 allowed more than 7 nested
finctions or up to 64, but I continue to get an error that says
"..........uses more level of functions than are allowed in the current
format." The formula is below.

=IF(MID($B2,39,3)="Eye","RM",IF(RIGHT($B2,2)="RM", "RM",IF(ISNUMBER(SEARCH("Gum",$B2,1)),"RON",IF(ISN UMBER(SEARCH("EyeWonder",$B2,1)),"RM",IF(ISNUMBER( SEARCH("Video",$B2,1)),"RM",IF(ISNUMBER(SEARCH("Ta rget",$B2,1)),"RON",IF(ISNUMBER(SEARCH("RM",$B2,1) ),"RM","Not Valid")))))))
--
Thank you for your help and support