Create Funtion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Swingstage - 05 Nov 2006 14:06 GMT

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 to this Message

Bob Phillips - 05 Nov 2006 16:17 GMT

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)

> Using this formula how can I create function "pastevalue"
> This formula would be in cell B5
[quoted text clipped - 3 lines]
> ENTRY!$C$2 is the Year to Date total
> Answer needed is the weekly value.

Reply to this Message

Barb Reinhardt - 05 Nov 2006 17:43 GMT

What exactly do you want to do with this workbook?

Reply to this Message

Swingstage - 05 Nov 2006 20:42 GMT

My Wife is a sales team leader and needs to generate sales reports but the
only accurate numbers she receives are year to date . To help her team
realize the good and bad in their numbers ,I have generated a sales report
that gives them their numbers in weekly form with a chart.
I have it working now but had to list every week separately making the data
input a bit harder then just updating one simple SS. Just trying to make
this easier for her.

> What exactly do you want to do with this workbook?
>
[quoted text clipped - 5 lines]
>> ENTRY!$C$2 is the Year to Date total
>> Answer needed is the weekly value.

Reply to this Message