 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / July 2008can 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! =IF(A1>1,B1&"s",B1) but note that if B1 has "mouse", this formula would return "mouses", not "mice". -- David Biddulph >i have 2 columns of cells. > column ONE is numeric (1,2,3,etc) [quoted text clipped - 3 lines] > > thanks! I think that perhaps if A1 were 0, The plural might be proper - 0 cats appeared today. not 0 cat appeared today. Therefore, maybe: =If(A1=1,B1,B1&"s")  SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > =IF(A1>1,B1&"s",B1) > but note that if B1 has "mouse", this formula would return "mouses", not [quoted text clipped - 9 lines] >> >> thanks! Hi, To do it in column B would require VB but you can put this in column C =IF(A1>1,B1&"s",B1) Mike > i have 2 columns of cells. > column ONE is numeric (1,2,3,etc) [quoted text clipped - 3 lines] > > thanks! that is AWESOME!!! BUT it leaves a space between the word and the S. how can i remove it? otherwise, my test looks like: trip trip s trip s trip thanks SO much for the F A S T reply!! > Hi, > [quoted text clipped - 11 lines] > > > > thanks! MY MISTAKE!!!! please disregard my previous post! i realized that i typed a space after the word(s). thanks for the great help, gentlemen!!! > that is AWESOME!!! > [quoted text clipped - 25 lines] > > > > > > thanks! Maybe something like this: A1 = 7 B1 = group C1: =B1&IF(A1>1,"s","") Then maybe hide column B. However, this depends on what the words are in column B because some plurals don't just add an S: box = boxes fish = fish or fishes city = cities SignatureBiff Microsoft Excel MVP >i have 2 columns of cells. > column ONE is numeric (1,2,3,etc) [quoted text clipped - 3 lines] > > thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.