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.

Hi,

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

"Casey" wrote:

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.

Thank you. Exactly what I needed.

"Eduardo" wrote:

Hi,

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

"Casey" wrote:

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.

your welcome, thanks for the feedback

"Casey" wrote:

Thank you. Exactly what I needed.

"Eduardo" wrote:

Hi,

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

"Casey" wrote:

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.