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

M

monkeydo

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
 
R

Rowan

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
 
M

monkeydo

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

monkeydo

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
 
R

Rowan

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
 
Top