What Formula to Use

[NAGYO]

Scenario:

C1R1 has a Yes or No Option

C2R1 has a "numerical value in it"

C3R1 needs a formula that would pick the numerical value in C2R1 if the
answer in C1R1 is "Yes" , if the answer is "No" it would put a "0" in that
column.

Thank you

 

[Sandy Mann]

Try:

=IF(R1C1="Yes",R2C1,0)

or:

=IF(A1="Yes",A2,0)

for A1 style

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Baffled]

C1R1 I presume is A1
C2R1 I presume is A2
C3R1 I presume is A3

this being so then the formula in A3 would be something like this
=IF(A1="Yes",A2,IF(A1="No",0))

Good Luck
D

 

[NAGYO]

Thank you Baffled, that worked.


So Suppose you have "Yes", "No", and "Maybe", and you want to assign a
value of "0" to "No" and "Maybe" but if Yes you want the Value in A2 to be
shown. How would that change the formula?

Thanks

 

[Baffled]

It would change like this
from =IF(A1="Yes",A2,IF(A1="No",0))
to
=IF(A1="Yes",A2,IF(A1="No",0, IF(A1="Maybe", 0)))

 

[NAGYO]

Thank you for all your help. I had come up with the same formula and your
post confirms it.