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!

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!

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!

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!

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!

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!

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!