Thread: Long formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jai jai is offline
external usenet poster
  
Posts: 71
Default Long formula
I wanted to shorten this formula throw lookup function. Please help me on this.

=If(A1=1,"a",if(a1=2,"b",if(a1=3,"C",if(a1=4,"D",i f(a1=5,"V","")))))

Thanks & regards

jai
Reply With QuoteReply With Quote