Dual income calculator help

A

ASasser

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.
 
P

Pete_UK

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
 
A

ASasser

THANK YOU!! I've been toying around with similar formulas, but hadn't quite
gotten it right. This works perfectly.
 
D

Dave Peterson

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))
 
P

Pete_UK

You're welcome - thanks for feeding back.

Pete

THANK YOU!!  I've been toying around with similar formulas, but hadn't quite
gotten it right.  This works perfectly.






- Show quoted text -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top