Formula Help

C

Casey

I am trying to figure out a formula in Excel 2000. Here is what I am trying
to do:

In one column I have a drop down menu with two options; "Weekly" and "2 per
Month". In the next column, I want these options to be represented by
numbers so if "Weekly" is selected, the number 4 would show up and if "2 per
Month" were chosen, the number 2 would display. I am able to do this. Here
is the formula I use:

=IF(C4="Weekly",4,2)

But what I was hoping I could do would be to have the cell blank if nothing
is selected. Right now, before anything is selected in the first column, a 2
shows in the second column. Any ideas how I can get rid of that until a
selection is made?

Thanks.
 

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

Link a text box based on drop down box with four options MS Word 365 0
Cumulative formula for word table 0
Setting column width in a table with a macro is not working 0
Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
Mail Merge Help 1
How to make repeating drop-down lists? 2
Weekly Report 2

Top