help?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Art - 20 Mar 2008 22:52 GMT

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?

Reply to this Message

Gary''s Student - 20 Mar 2008 23:00 GMT

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

Signature

Gary''s Student - gsnu200774

> 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,
[quoted text clipped - 3 lines]
> to put in a formula in that cell so it can calculate answer. Can someone help
> me?

Reply to this Message