Thread: can i create formula to make cell PLURAL if other cell is 1?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
me@BBB me@BBB is offline
external usenet poster
  
Posts: 3
Default can i create formula to make cell PLURAL if other cell is 1?
i have 2 columns of cells.
column ONE is numeric (1,2,3,etc)
column TWO is text (group, trip, etc)
what forumla can i use to make column TWO to be plural based upon whether
column ONE is greater than one or not?

thanks!
Reply With QuoteReply With Quote