# If one cell says 'yes' another cell is populated with a third cells value

1. ## If one cell says 'yes' another cell is populated with a third cells value

D19 is blank
B19 has a value in it.
C19 says 'Yes/No

I need D19 to populate with B19's value if C19 says Yes. I also need D19 to show 0 if C19 says No

Any help?

2. ## Re: If one cell says 'yes' another cell is populated with a third cells value

Assuming you can only have Yes or No in C19
put in D19
=If( C19="no", 0, B19)
OR
=IF( C19="NO", 0, IF( C19="YES", B19, "C19 does not equal Yes or No"))

3. ## Re: If one cell says 'yes' another cell is populated with a third cells value

A simple IF statemet?

=IF(C19="Yes",B19,0)

4. ## Re: If one cell says 'yes' another cell is populated with a third cells value

Insert this into D19
=IF(C19="No","0",IF(C19="Yes",B19,""))

5. ## Re: If one cell says 'yes' another cell is populated with a third cells value

Hi, In C19

Formula:
`Please Login or Register  to view this content.`

6. ## Re: If one cell says 'yes' another cell is populated with a third cells value

THANKS GUYS, THE nO FUNCTION WORKS FOR ALL BUT NONE OF THEM ALLOW THE YES FUNCTION TO WORK FOR SOME REASON

7. ## Re: If one cell says 'yes' another cell is populated with a third cells value

BUT NONE OF THEM ALLOW THE YES FUNCTION TO WORK
check you have YES and not YES with a space in at all " YES" or "YES "

8. ## Re: If one cell says 'yes' another cell is populated with a third cells value

Ok got it, just had an extra space. Thank you for your help guys, much appreciated.

9. ## Re: If one cell says 'yes' another cell is populated with a third cells value

your welcome - thanks for the rep

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1