Formula help

[caloy]

I have a three number selection (1,2,3) for ("Yes", "No", "N/A")
respectively. I am looking for a formula that would calculate these
selections with different values attached to them.

Ex. If I have selection 1 (YES) with a value of 2 then I want 2 to show
else, if selection 2, then zero (0) else if selection 3, then blank.

Again, If I have selection 1 (YES) with a value of 8 then I want 8 to show
else, if selection 2, then zero (0) else if selection 3, then blank.

....and so on and so forth. I thought an IF statement might work but, cna't
quite put it together.
--
Caloyski

[Duke Carey]

=IF(selection=1,value,IF(selection=2,0,""))

"caloy" wrote:

> I have a three number selection (1,2,3) for ("Yes", "No", "N/A")
> respectively. I am looking for a formula that would calculate these
> selections with different values attached to them.
>
> Ex. If I have selection 1 (YES) with a value of 2 then I want 2 to show
> else, if selection 2, then zero (0) else if selection 3, then blank.
>
> Again, If I have selection 1 (YES) with a value of 8 then I want 8 to show
> else, if selection 2, then zero (0) else if selection 3, then blank.
>
> ...and so on and so forth. I thought an IF statement might work but, cna't
> quite put it together.
> --
> Caloyski