Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions |