Hi everyone, I'm doing a data entry task for packaged food products.
Lets say we have a cell D1. I don't know if D1 is blank or not. If D1 is blank, I want its value to be equal to the value of cell E1. Is there a formula for this?
Hi everyone, I'm doing a data entry task for packaged food products.
Lets say we have a cell D1. I don't know if D1 is blank or not. If D1 is blank, I want its value to be equal to the value of cell E1. Is there a formula for this?
Not in D1, but in F1 you could add =if(D1="",E1,D1).
If, as in your example, you are always looking at column D and if column D is blank you are always looking at column E then I would use the following:
=IF(ISBLANK(D1)=true, E1, D1)
Now if you are looking for if column D is blank then check for the next in the row that isn't blank, then you've gotten too complicated for me as I would just start stringing together embedded IF statements, which really slows down the sheet. Try the formula above and see if it helps.
From the sounds of it, D1 is supposed to contain data, but you are unsure if it does or not?
A cell can contain either data OR a formula, not both. So if you have a formula in D1 that references E1, as soon as you enter something in D1, that formula gets over-written
I think you are going to need to explain a bit more - and maybe provide a sample workbook - so we understand better?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hmm, ok.
So to give a bit of background: I have a 2000 odd list of data on packaged drink products that I have to decompose into flavor, natural/organic, product name, etc.
What I've done so far is use the formula =IF(ISNUMBER(FIND("FLAVOR",cell)),"Flavor","") in the each column next to the original data. Each column has a different flavor in place of FLAVOR.
So now I have a bunch of columns next to the original data, one for Strawberry, one for Grape, one for Orange, etc. I've alsoedited the columns so that the original formulas are gone, and only the values are left over.
Want I want to do is put all those columns together into one 'Flavor' column. Is there any quick and simple way to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks