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.