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?
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?
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"))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
A simple IF statemet?
=IF(C19="Yes",B19,0)
Insert this into D19
=IF(C19="No","0",IF(C19="Yes",B19,""))
Hi, In C19
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
THANKS GUYS, THE nO FUNCTION WORKS FOR ALL BUT NONE OF THEM ALLOW THE YES FUNCTION TO WORK FOR SOME REASON
check you have YES and not YES with a space in at all " YES" or "YES "BUT NONE OF THEM ALLOW THE YES FUNCTION TO WORK
Ok got it, just had an extra space. Thank you for your help guys, much appreciated.
your welcome - thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks