LinkBack URL
About LinkBacks
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
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 exampleOriginally Posted by stevesunfold
=if(a18=1,"yep","")
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.....
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",""))
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
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?
IN CELL A19 OF SHEET 2 I WANT IT TO RETURN THE DATA IN CELL D13 OF SHEET1 WHICH IT DOES
IN CELL B19 OF SHEET 2 I HAVE THIS FORMULA IN IT =IF(A19=1,"Unit",IF(A19>1,"Units",""))
BUT I WANT CELL B19 TO REMAIN EMPTY IF THERE IS NOTHING IN A19 IN IT
MAYBE BECAUSE THERE IS A FORMULA IN A19 IT IS ALWAYS RETURNING THE WORD UNITS RATHER THAN BEING BLANK
Change your formula in B19 to:
=IF(A19=1,"Unit",IF(AND(A19<>"",A19>1),"Units",""))
Excel sees a blank (which is text string) as greater that a number....so you have to work around it.
absolutely superb
i really appreciate it very much
thanks guys
i promise not to bug you anymore today guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks