Thread: 7 Function rule
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 7 Function rule

On Thu, 28 Dec 2006 14:27:01 -0800, HELPME
wrote:

Is there a way around the excel rule that you may only have 7 functions in
one formula, im trying to do an if statemet with like 15 IFs.....can this be
done


Not in versions prior to XL2007.

There's most likely another solution that is also simpler, than trying to nest
15 IF statements. If you post some details of what you are trying to
accomplish, someone will help.
--ron