if(and arguments

  sms 14:29 20 Mar 2007
Locked

I am using if(and( argument on a spreadsheet in exel 2007.
It only allows me to use 7 arguments. Is it possible to increase this level in 2007

  VoG II 14:37 20 Mar 2007

According to click here the new limit is 64. If anybody can keep track of a 64-level nested IF they deserve a medal or something.

  sms 14:56 20 Mar 2007

The file was originally created in office 2000. How can I enable it to be used in 2007 and get the extra features. I have tried "save as" and then file type up to 2003. Tnere is no 2007.

  VoG II 15:04 20 Mar 2007

Can't you just open it in Excel 2007?

  sms 15:08 20 Mar 2007

It opens fine in 2007. But when I try to add argumnets it says I can only have 7
What to do ?

  VoG II 15:14 20 Mar 2007

Try saving the fie and in the Save as type drop-down make sure the type is Excel Workbook.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires