Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: If Cell Equals Text Then Return Another Cell

1. I agreed to these rules
Join Date
21st August 2008
Posts
10

## If Cell Equals Text Then Return Another Cell

I need a formula that If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell...

at the mo i've got

=IF(A2="PAID OUT", "OK", "Not OK")

but instead of the cell reading OK or Not OK, i need it to equal another cell. ie, if A2="PAID OUT", then =B2

how do i do that?

Excel Video Tutorials / Excel Dashboards Reports

2. Member
Join Date
9th June 2007
Posts
70

## Re: If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell?!

Hi,

=IF(A2="PAID OUT", B2, "Not OK")

Eric

Excel Video Tutorials / Excel Dashboards Reports

3. ## Re: If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell?!

and cue Dave...

;-)

Excel Video Tutorials / Excel Dashboards Reports

##### Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 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