I am trying to establish a formula, but not too sure how.
For example " If Cell A5 has been marked with ' X ', then copy what is in Cell A6 to
cell C25 "
I am trying to establish a formula, but not too sure how.
For example " If Cell A5 has been marked with ' X ', then copy what is in Cell A6 to
cell C25 "
Re: Copy If Formula Help please
Is it?
Quote
C25 =IF(A5="X",A6,"")
Re: Copy If Formula Help please
That formula when I enter it, it stays as a text, not too sure why?
Also please:
What if I need to copy text or numbers from a range of cells to one cell. Is this possible?
" If Cell A5 to A10 has been marked with ' X ', then copy what is in Cell A6 to A10
into cell C25 "
Re: If cell equals X return value from other cell
Can you give more detail and perhaps send an example of your file.
If A5=A6=...A10 = X
C25 = XXXXXXXXX
????
Re: If cell equals X return value from other cell
Just to rule this out since you said that the formula stays as text. You did put this first one into cell C25:
Quote=IF(A5="X",A6,"")
versus:
Quote
C25 =IF(A5="X",A6,"")
Don’t have an account yet? Register yourself now and be a part of our community!