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.

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.

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.