If column c # is 101..then column e is $14.32 & column g is $8.00
 

help!!
I need to be able to put a code # in column C, then automatically column E
would be $14.32 each time I would put that code in column C.I have tried all
day to do this.
p.s. Column G would be nice to automatically put in there also, but I don't
want to ask for too much. If I could even do the first two, I would be happy.


using office 2003

maybe:

In E1 enter the formula =IF(C1="#",14.32,"")
Format the cell as currency and then copy down to the end of you data.

Similarly: in G1 enter =IF(C1="#",8,"")
Again, format as currency and copy down to end of data.

Hope this helps
Rowan

monkeydo wrote:
help!!
I need to be able to put a code # in column C, then automatically column E
would be $14.32 each time I would put that code in column C.I have tried all
day to do this.
p.s. Column G would be nice to automatically put in there also, but I don't
want to ask for too much. If I could even do the first two, I would be happy.


using office 2003

Thank you sooo much, Rowan. I haven't tried it yet, but I appreciate your
response.
Monkeydo

"Rowan" wrote:

maybe:

In E1 enter the formula =IF(C1="#",14.32,"")
Format the cell as currency and then copy down to the end of you data.

Similarly: in G1 enter =IF(C1="#",8,"")
Again, format as currency and copy down to end of data.

Hope this helps
Rowan

monkeydo wrote:
help!!
I need to be able to put a code # in column C, then automatically column E
would be $14.32 each time I would put that code in column C.I have tried all
day to do this.
p.s. Column G would be nice to automatically put in there also, but I don't
want to ask for too much. If I could even do the first two, I would be happy.


using office 2003

Rowan,
I did the formula, but answer didn't automatically appear in E1. What am I
missing? Also, "How to copy to end of data.
thanks
Monkeydo

"monkeydo" wrote:

help!!
I need to be able to put a code # in column C, then automatically column E
would be $14.32 each time I would put that code in column C.I have tried all
day to do this.
p.s. Column G would be nice to automatically put in there also, but I don't
want to ask for too much. If I could even do the first two, I would be happy.


using office 2003

Try =IF(C1=101,14.32,"") and in column G =IF(C1=101,8,"").

To copy down hover the mouse over the bottom right hand corner of the
cell so that the mouse pointer becomes a black cross. Then click and
drag down as far as required.

Regards
Rowan

monkeydo wrote:
Rowan,
I did the formula, but answer didn't automatically appear in E1. What am I
missing? Also, "How to copy to end of data.
thanks
Monkeydo

"monkeydo" wrote:


help!!
I need to be able to put a code # in column C, then automatically column E
would be $14.32 each time I would put that code in column C.I have tried all
day to do this.
p.s. Column G would be nice to automatically put in there also, but I don't
want to ask for too much. If I could even do the first two, I would be happy.


using office 2003