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.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017