View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default I WANT TO USE =IF(AND(),IF(AND(),IF(AND()).

Hi,

You can nest up to 7 deep, anything after that will fail.

Mike

"gopal sharma" wrote:

i want to use if(and) function more than one time. how long can i use this
function in a formula.