Fill or empty fields
I have a spreed sheet with over 5000 products. I want to write a formula that looks at cell I-1 and if it is empty make R-1 empty as well; but if it is not empty, leave R-1 as is.
I know this is simple but I can't seem to write the formula to work.
Help please?
Are I1 and R1 the only cells you want to do this for, or will it be for more cells?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Him and welcome to the forum,
Unfortunately you can't have both a formula in R1 and also a value that you manually enter. You can achieve this with a VBA macro but not without. YOu could have a third cell and use
Formula:
Please Login or Register to view this content.
then use the third cell for whatever you were going to use R1 for.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Exactly what I was thinking Richard (guess I should have said so). I had actually wrote a code in a Worksheet Change for this, hence my question about this I1, R1 being the only cells or if there were multiple cells, so that I didn't' give OP the wrong code.
Yes there will be other cells to be empty. What I have is, I2 & R2 have a value that needs to remain in the cell. But I1 is empty and R1 is not. So I want to create a formula to fill down the entire workbook that if I1 has a value in it, R1 will retain its value after the fill takes place. But if I1 is empty, then R1 is to become empty after running the fill down. I hope this helps.
A formula cannot change the contents of another cell, it can only affect the cell it is in. And, as has been said already, you cannot have a number in a cell AND a formula, you can only have 1 OR the other
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
An alternative could be to use cell S2 (a helpcolumn) for the formula.
Edit:
as already added by Richard Buttrey in #3.
Last edited by oeldere; 11-29-2015 at 06:07 AM. Reason: Edit added
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You've not indicated whether a third helper cell would address your request. See #3. If you aren't happy to use a helper cell and use that for whatever you want then you will need a VBA macro. However unless there's some strange reason why you can't use a third helper cell the you should use that.Originally Posted by DTEInc
..thanks for the Rep. Not sure if your Q. has been satisfactorily answered but if so when you have a moment would you edit the original post and mark it as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks