Here's the formulas you need ...
Posted By: Exceller on 2007-07-28
In Reply to: Excel question - Rad MT
Set up 5 columns:
A = Record Date
B = Exam number
C = Characters
D = Lines
E = Report Pay
The formula for dividing number of characters by 65 to get lines is this:
=C#/65
where # is the row number
The formula for get the report pay is this:
=D#*0.1
where # is the row number
Make sure you format the cells under column E to read in currency.
Complete Discussion Below: marks the location of current message within thread
The messages you are viewing
are archived/old. To view latest messages and participate in discussions, select
the boards given in left menu
Other related messages found in our database
|