| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Create Funtion
Using this formula how can I create function "pastevalue"
This formula would be in cell B5 =IF(ENTRY!$B$1=2,pastevalue(ENTRY!$C$2)-B4,0) ENTRY!$B$1 is the week of the year ENTRY!$C$2 is the Year to Date total Answer needed is the weekly value. |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
|
Create Funtion
You can't paste the value from a function, as functions cannot change cells,
it will still be a formula in the cell. And why wouldn't it just be =IF(ENTRY!$B$1=2,ENTRY!$C$2/ENTRY!$B$1,0) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Swingstage" wrote in message ... Using this formula how can I create function "pastevalue" This formula would be in cell B5 =IF(ENTRY!$B$1=2,pastevalue(ENTRY!$C$2)-B4,0) ENTRY!$B$1 is the week of the year ENTRY!$C$2 is the Year to Date total Answer needed is the weekly value. |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
Create Funtion
What exactly do you want to do with this workbook?
"Swingstage" wrote: Using this formula how can I create function "pastevalue" This formula would be in cell B5 =IF(ENTRY!$B$1=2,pastevalue(ENTRY!$C$2)-B4,0) ENTRY!$B$1 is the week of the year ENTRY!$C$2 is the Year to Date total Answer needed is the weekly value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
| Create database in excel? | New Users to Excel | |||
| quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
| Create a tabular control | Excel Discussion (Misc queries) | |||
Linear Mode
