Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: If cell equals X return value from other cell

1. I agreed to these rules
Join Date
12th July 2010
Posts
2

## If cell equals X return value from other cell

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 "
Last edited by AAE; July 12th, 2010 at 20:10. Reason: Amend thread title

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Copy If Formula Help please

Is it?
C25 =IF(A5="X",A6,"")

3. I agreed to these rules
Join Date
12th July 2010
Posts
2

## Re: Copy If Formula Help please

That formula when I enter it, it stays as a text, not too sure why?

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 "
Last edited by AAE; July 13th, 2010 at 03:58. Reason: delete unnecessary quote

Excel Video Tutorials / Excel Dashboards Reports

4. ## 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
????

5. ## 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:

=IF(A5="X",A6,"")
versus:

C25 =IF(A5="X",A6,"")

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno