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.

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.

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.

Insert a new worksheet.
Name it PayTable
Put all the report types that you use in column A.
Put all the per line price in column B.

Then you can use this kind of formula in E2:

=if(c2="","",d2*vlookup(c2,paytable!a:b,2,false))



ASasser wrote:

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.

--

Dave Peterson

ps.

Debra Dalgleish has lots of notes on =vlookup()"
http://www.contextures.com/xlFunctions02.html
and
http://contextures.com/xlFunctions02.html#Trouble

ASasser wrote:

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.

--

Dave Peterson

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 -