Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula in excel
I have a rather large personnel spreadsheet which I am collating every
employee's details into, a similar but less extensive and recent spreadsheet had a formula to calculate people's age, using the day's date and their inputted dob. Now am not so stupid that didn't think to copy it into my new spreadsheet, which I have done and it works. However when I try to copy throughout the specific column that I require it for, I am told that there has been an error VALUE! appears in each cell. When I click into the individual cells the formula has changed from the cell in which the current day's date is held to another: the day's date is in column B1 and the incorrect formula will remain in B column but will move to the line that the cell I wish the formula to be placed in is held. Does this make sense? I don't really want to have to manually into this formula into each corresponding cell as it will take me to Christmas, next year! Cheers Rhianne |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula in excel
Your formula that works will be referring to cell B1. Change all
references to B1 to $B$1 instead, and then copy the formula down the column. Hope this helps. Pete On Nov 13, 9:00*am, Rhianne wrote: I have a rather large personnel spreadsheet which I am collating every employee's details into, a similar but less extensive and recent spreadsheet had a formula to calculate people's age, using the day's date and their inputted dob. Now am not so stupid that didn't think to copy it into my new spreadsheet, which I have done and it works. However when I try to copy throughout the specific column that I require it for, I am told that there has been an error VALUE! appears in each cell. When I click into the individual cells the formula has changed from the cell in which the current day's date is held to another: the day's date is in column B1 and the incorrect formula will remain in B column but will move to the line that the cell I wish the formula to be placed in is held. Does this make sense? I don't really want to have to manually into this formula into each corresponding cell as it will take me to Christmas, next year! Cheers Rhianne |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula in excel
Many thanks! Top tip!!
"Pete_UK" wrote: Your formula that works will be referring to cell B1. Change all references to B1 to $B$1 instead, and then copy the formula down the column. Hope this helps. Pete On Nov 13, 9:00 am, Rhianne wrote: I have a rather large personnel spreadsheet which I am collating every employee's details into, a similar but less extensive and recent spreadsheet had a formula to calculate people's age, using the day's date and their inputted dob. Now am not so stupid that didn't think to copy it into my new spreadsheet, which I have done and it works. However when I try to copy throughout the specific column that I require it for, I am told that there has been an error VALUE! appears in each cell. When I click into the individual cells the formula has changed from the cell in which the current day's date is held to another: the day's date is in column B1 and the incorrect formula will remain in B column but will move to the line that the cell I wish the formula to be placed in is held. Does this make sense? I don't really want to have to manually into this formula into each corresponding cell as it will take me to Christmas, next year! Cheers Rhianne |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula in excel
You're welcome - glad it worked for you.
Pete On Nov 13, 10:49*am, Rhianne wrote: Many thanks! Top tip!! "Pete_UK" wrote: Your formula that works will be referring to cell B1. Change all references to B1 to $B$1 instead, and then copy the formula down the column. Hope this helps. Pete On Nov 13, 9:00 am, Rhianne wrote: I have a rather large personnel spreadsheet which I am collating every employee's details into, a similar but less extensive and recent spreadsheet had a formula to calculate people's age, using the day's date and their inputted dob. Now am not so stupid that didn't think to copy it into my new spreadsheet, which I have done and it works. However when I try to copy throughout the specific column that I require it for, I am told that there has been an error VALUE! appears in each cell. When I click into the individual cells the formula has changed from the cell in which the current day's date is held to another: the day's date is in column B1 and the incorrect formula will remain in B column but will move to the line that the cell I wish the formula to be placed in is held. Does this make sense? I don't really want to have to manually into this formula into each corresponding cell as it will take me to Christmas, next year! Cheers Rhianne- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |