Thread: Is it possible?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Is it possible?
Hi Bobbie Jo,

I'm sure someone will come up with a simpler way but one
that will work is this

=IF(B1=6,500,"")&IF(B1=7,600,"")&IF(B1=8,700,"") etc. etc.

HTH
Martin


Reply With QuoteReply With Quote