LinkBack URL
About LinkBacks
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
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...Originally Posted by stevesunfold
try this,
=IF(A1=1,"Unit",IF(A1>1,"Units",""))
dave
youre a star thanks so much thats spot on
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
dave
please?
You want?
In sheet2 A19:
=If(sheet1!D13="","",Sheet1!D13)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks