Function help excel 2003

[Jason]

I am trying make an auto popluate function from a drop down menu. Such as: if
(drop down) I3 equals "x" then pupulate c2:c42:c74 etc. with g3.

I am trying to auto populate cells in a budget. So the question for g3 is
how much are your paychecks. The drop down menu is frequency of pay such as
1st friday 2nd friday 3rd friday etc. c2:c42:c74 are 1st friday 2nd friday
3rd friday from a calender.

Thanks for any help, Jason

 

[Max]

.. if (drop down) I3 equals "x" then populate c2:c42:c74 etc. with g3.

Easiest way is to place this simple formula
in each of the cells: c2, c42, c74 etc:
=IF(I3="x",G3,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

 

[Jason]

Max, Thanks for the fast response. Is there a way to keep my "x" labeled as
1st sunday etc. or do I have to change it to a number?

Jason

 

[Max]

Is there a way to keep my "x" labeled as 1st sunday etc.

or do I have to change it to a number?

Sorry, I'm really not following you on the above.
Try clarifying further with sample data, expected results, etc?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

 

[Jason]

Thanks, My drop down menu is located in I13 and that was my "x" value in the
original question. The drop down options are: 1st Sunday 2nd Sunday etc., I
tried your solution with good results, however it only works when I replace
the labels "1st Sunday" with a number. I tried adding "1st Sunday" as a NAME
in hope of using the label "1st Sunday" in the formula.

=IF(O4='1st Sunday',M4," ") doesnt work

however =IF(O4=0,M4," ") does work

although I lose my original intention in labeling the days of the week.

Thanks

 

[Max]

=IF(O4='1st Sunday',M4," ") doesnt work

For text, you need to enclose it within double quotes in the expression, not
single quotes

This replacement should work fine:
=IF(O4="1st Sunday",M4,"")

p/s: To avoid potential downstream issues, would also suggest that you
always use
zero length null strings: "" instead of: " " as returns
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

 

[Shane Devenshire]

Hi,

If your formula is as your wrote it

=IF(O4='1st Sunday',M4," ")

Then change it to read

=IF(O4="1st Sunday",M4,"")

The key here is the single quotes in your original formula verses the double
quotes in mine. The " " thing displays the same with "" and but your
really should use "" to mean blank, the other approach could lead to problems
elsewhere.