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!
|