if(and arguments

  sms 14:29 20 Mar 07
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 07

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 07

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 07

Can't you just open it in Excel 2007?

  sms 15:08 20 Mar 07

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 07

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…