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