how to write a formula
 

I have just taken over as manager of a boarding house and need to come up
with some formulas to allow me to enter a dollar amount in cells c1:c12 and
then have excel convert that to a day value( 1 day = 13.57) , it then needs
to take the date in cells d1:d12 add the reultant conversion and place the
result in cells e1:e12 as a date in real time ( 23/05/205). Also is it
possible to get excell to print out a receipt for each entry that is made.

I have never used excell and currently do it manually with Word which is
hard and long

In E1, just enter =D1+(C1/13.57), format as date and copy down to E12

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wolfmasterr" wrote in message
...
I have just taken over as manager of a boarding house and need to come up
with some formulas to allow me to enter a dollar amount in cells c1:c12
and
then have excel convert that to a day value( 1 day = 13.57) , it then
needs
to take the date in cells d1:d12 add the reultant conversion and place the
result in cells e1:e12 as a date in real time ( 23/05/205). Also is it
possible to get excell to print out a receipt for each entry that is made.

I have never used excell and currently do it manually with Word which is
hard and long

"wolfmasterr" wrote:

I have just taken over as manager of a boarding house and need to come up
with some formulas to allow me to enter a dollar amount in cells c1:c12 and
then have excel convert that to a day value( 1 day = 13.57) , it then needs
to take the date in cells d1:d12 add the reultant conversion and place the
result in cells e1:e12 as a date in real time ( 23/05/205). Also is it
possible to get excell to print out a receipt for each entry that is made.

Enter =D1+(C1/13.57) into cell E1 and copy it down to E12

thankyou both it works like a treat


"Bob Phillips" wrote:

In E1, just enter =D1+(C1/13.57), format as date and copy down to E12

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wolfmasterr" wrote in message
...
I have just taken over as manager of a boarding house and need to come up
with some formulas to allow me to enter a dollar amount in cells c1:c12
and
then have excel convert that to a day value( 1 day = 13.57) , it then
needs
to take the date in cells d1:d12 add the reultant conversion and place the
result in cells e1:e12 as a date in real time ( 23/05/205). Also is it
possible to get excell to print out a receipt for each entry that is made.

I have never used excell and currently do it manually with Word which is
hard and long