returning something in a cell if another cell has info input

[stevesunfold]

hi guys

im trying to get my spreadsheet to return the word unit if cell a18=1 or the word units if its over 1 but i also want the cell to remain empty if there is nothing input into cell a18 is this possible

help gratefully received

[davesexcel]

hi guys

im trying to get my spreadsheet to return the word unit if cell a18=1 or the word units if its over 1 but i also want the cell to remain empty if there is nothing input into cell a18 is this possible

help gratefully received

place this in B18 for example
=if(a18=1,"yep","")

[stevesunfold]

hi dave but what if it is 2 or more

[davesexcel]

hi dave but what if it is 2 or more

Oh,
Do you want the the number changed to words in a different cell?
like
one for 1
two for 2
three.....

[stevesunfold]

hi dave
no
if a18=1 then i want the word "unit" to appear in cell a19
but if a18>1 then i want the word "units" in cell a19
and if there is nothing input in cell a18 then i want a19 to remain blank


thanks for your time

[davesexcel]

hi dave
no
if a18=1 then i want the word "unit" to appear in cell a19
but if a18>1 then i want the word "units" in cell a19
and if there is nothing input in cell a18 then i want a19 to remain blank


thanks for your time

Sure...
try this,
=IF(A1=1,"Unit",IF(A1>1,"Units",""))