Thread: too many nested IF functions
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default too many nested IF functions
Hi Amanda,

One way is to join them together as seperate IF functions
rather than nesting i.e.

=IF(D3="Especial",(((H3-0.12)*1.4)+0.3),"")&IF(D3="Nacional",(((H3-0.12)*1.4)+0.3),"")&IF(D3="Llam.Interna",(((H3-0.12)*1.4)+0.3),"")&IF(D3=.......
etc. etc.

HTH
Martin


Reply With QuoteReply With Quote