Can someone help me with a formula? I 'm using a dropdown menu in one cell,
in the other cell I need the answer. The dropdown list cell has a y for yes,
n for no.
The other cell where the answer will go needs to show if i pick N from
dropdown list , it needed to show 0. If I pick Y from dropdown list in needs
to put in a formula in that cell so it can calculate answer. Can someone help
me?

Here is an example. Cell a1 will have either y or n; in B1 enter:

=IF(A1="n",0,C1+D1)

put your formula in inplace of C1+D1
--
Gary''s Student - gsnu200774


"Art" wrote:

Can someone help me with a formula? I 'm using a dropdown menu in one cell,
in the other cell I need the answer. The dropdown list cell has a y for yes,
n for no.
The other cell where the answer will go needs to show if i pick N from
dropdown list , it needed to show 0. If I pick Y from dropdown list in needs
to put in a formula in that cell so it can calculate answer. Can someone help
me?