Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i create formula to make cell PLURAL if other cell is 1?
=IF(A11,B1&"s",B1)
but note that if B1 has "mouse", this formula would return "mouses", not "mice". -- David Biddulph "me@BBB" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i create formula to make cell PLURAL if other cell is 1?
Hi,
To do it in column B would require VB but you can put this in column C =IF(A11,B1&"s",B1) Mike "me@BBB" wrote: 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i create formula to make cell PLURAL if other cell is 1?
Maybe something like this:
A1 = 7 B1 = group C1: =B1&IF(A11,"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 -- Biff Microsoft Excel MVP "me@BBB" wrote in message ... 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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i create formula to make cell PLURAL if other cell is 1?
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!! "Mike H" wrote: Hi, To do it in column B would require VB but you can put this in column C =IF(A11,B1&"s",B1) Mike "me@BBB" wrote: 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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i create formula to make cell PLURAL if other cell is 1?
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") -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =IF(A11,B1&"s",B1) but note that if B1 has "mouse", this formula would return "mouses", not "mice". -- David Biddulph "me@BBB" wrote in message ... 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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i create formula to make cell PLURAL if other cell is 1?
MY MISTAKE!!!! please disregard my previous post! i realized that i typed a
space after the word(s). thanks for the great help, gentlemen!!! "me@BBB" wrote: 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!! "Mike H" wrote: Hi, To do it in column B would require VB but you can put this in column C =IF(A11,B1&"s",B1) Mike "me@BBB" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Make cell value zero if cell formula returns value less than zero? | Excel Discussion (Misc queries) | |||
function in to make text plural? | Excel Worksheet Functions | |||
Need to make text plural?? | Excel Worksheet Functions | |||
Make an Excel cell create a new sequential number each printing | Excel Discussion (Misc queries) |