ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula Help (https://www.excelbanter.com/excel-discussion-misc-queries/241311-formula-help.html)

casey

Formula Help
 
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.

Eduardo

Formula Help
 
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.


casey

Formula Help
 
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.


Eduardo

Formula Help
 
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.



All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com