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" wrote:

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
--
NAGYO


"Baffled" wrote:

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" wrote:

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
--
NAGYO