help?

A

Art

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?
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help 2
Help With MS Access 4
How do i show the drop down arrow for a list in Excel 1
Time sheet validation 2
Double Drop-Down Validation in Excel 2007 1
Displaying arrow in a dropdown list within cell 2
if(isna(match formula 8
Vlook up + Lists 1

Top