Thread: Formula help for choosing from a set of values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Anas Mike Anas is offline
external usenet poster
  
Posts: 9
Default Formula help for choosing from a set of values
If data in columns A, B, and C then

=if(isblank(c1)=false,c1,if(isblank(b1)=false,b1,a 1))

Mike Anas
http://mikeanas.googlepages.com/
Reply With QuoteReply With Quote