returning something in a cell if another cell has info input

**stevesunfold** · 04-01-2008, 06:41 AM

hi dave but what if it is 2 or more

**davesexcel** · 04-01-2008, 06:56 AM

Originally Posted by stevesunfold

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** · 04-01-2008, 07:00 AM

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** · 04-01-2008, 07:06 AM

Originally Posted by 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

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

**stevesunfold** · 04-01-2008, 07:11 AM

dave

youre a star thanks so much thats spot on

**stevesunfold** · 04-01-2008, 07:14 AM

i have the same problem whereas i want whats in cell d13 on sheet 1 to appear in cell a19 on sheet 2 but again if its empty i want the 2nd sheet to remain empty

thanks dave
sorry to be a pain

**stevesunfold** · 04-01-2008, 07:38 AM

dave

please?

returning something in a cell if another cell has info input

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions