Thread: changing nested if statements into a user defined function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Slagle Rob Slagle is offline
external usenet poster
  
Posts: 1
Default changing nested if statements into a user defined function
I have several financial worksheets where I am figuring a percent change
with a nested if(and statements.

c1 =if(and(a1=0,b1<0),-1,if(and(a1=0,b10),1,....etc.

how do I make this into a user defined function?


Reply With QuoteReply With Quote