You're welcome - thanks for feeding back.

Pete

On Jul 2, 2:19*am, ASasser wrote:
THANK YOU!! *I've been toying around with similar formulas, but hadn't quite
gotten it right. *This works perfectly.



"Pete_UK" wrote:
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.- Hide quoted text -

- Show quoted text -