If you only have those two types of report, then you can do it by putting
this formula in column E:

=IF(C2="ST",0.065,0.025)*D2

Then copy this down as required.

Hope this helps.

Pete

"ASasser" wrote in message
...
I am paid by the line typed/edited. I want to make a spreadsheet that will
allow me to enter the report type and the line count and have the
spreadsheet
calculate the pay I will receive for each report. For instance, this is
how
I have it set up so far:

Column C Column D Colulmn E
Report Type # of Lines Pay

VR 14
ST 25

Ok. My VR pay is $0.025 per line and ST pay is $0.065 per line.

Is there a way to make this work so I can just copy the same formula for
each line in Column E? I'm using Excel XP (2002).

Thanks.