returning something in a cell if another cell has info input

**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?

**NBVC** · 04-01-2008, 07:41 AM

You want?

In sheet2 A19:

=If(sheet1!D13="","",Sheet1!D13)

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

NBVC THANKS ALOT
IVE THINK IVE DONE THIS THE WRONG WAY ROUND BECAUSE
WITH THAT FORMULA IN A19 ( =If(sheet1!D13="","",Sheet1!D13)
) IM NOW GETTING THE PREVIOUS QUESTION ABOUT UNITS AND UNIT IN ALL MY CELLS AND ITS NOT STAYING BLANK

**NBVC** · 04-01-2008, 08:14 AM

I'm not sure what you mean..

My formula will put what is in Sheet1, cell D13 in Sheet2, cell A19.... is that wrong?

If so, what exactly do you need?

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