What Formula to Use
 

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

What Formula to Use
 

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


Replace @mailinator.com with @tiscali.co.uk


"NAGYO" .(donotspam) wrote in message
...
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

What Formula to Use
 

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

What Formula to Use
 

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

What Formula to Use
 

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

What Formula to Use
 

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


--
NAGYO


"Baffled" wrote:

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