Thread: Multiple IF functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harry S[_2_] Harry S[_2_] is offline
external usenet poster
  
Posts: 1
Default Multiple IF functions
I like to enter a multiple IF funcution formula that looks like this:
=if(a10<5,x1+1,if(a105<10,x1+2,if(a1010<20,x1+3) ))
Always getting an FALSE message what am I doing wrong?

--
Harry S
Reply With QuoteReply With Quote