Is there a way to paste a cell's value and not its function to another cell if a certain cell says "Yes"
Thanks
Is there a way to paste a cell's value and not its function to another cell if a certain cell says "Yes"
Thanks
Not sure I understand the question.
Can you give an example
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Okay, If B2 = Yes then copy the number of C2 (not the function) to A2
is this what you are wanting? =IF(B2="yes",C2,"") in A2?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
@Sambo kid: If C2 contains a function that will copy the function and OP said he didnt want that.
Paste values will copy a cell's value.
Though I cant see why copying the value or the function would make any difference to the result.
I'm now wondering if OP means the address of the cell.
Special-K, that is why I was asking, because even if the "number" (if that is what is in C2) are the results of a function, excel will pull over the "number". So for example if C2 had the formula =2+4 showing in the function bar and the cell showed 6 and B2 had yes in it, what would show in A2 would be the 6. I have no doubts YOU know this but was wondering if NZL understands that?
Sambo Kid that seems like what I need, yeah. Is there a way?
Ok NQL, I'm not sure based on the exchanges that I understand what you want so I'm attaching a sample sheet.
In cells A2 & A3 are the formulas similar to what I proposed in post #4 above. In cells B2 & B3 are examples of yes or no (hard coded) and in cells C2 & C3 are formulas. The results of the formulas appear as numbers in the cell but in the function bar the formulas can be seen. In A2 and A3 you see the results of those if/then statements. Again if you click on either A2 or A3 you also see the formulas in the function bar even though on the sheet the "values" appear to you. Excel treats the results of formulas as values. So if you graphed the results in either col C or col A you will see the numbers appear.
If however you want the formulas to "disappear" from either col A or col C you would need to do a copy, paste special >> values to make that happen (as Special-K mentioned previously).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks