Hi guys, I am in need of a wee hand.

I have 2 columns, C & D.

C is a weekly column where an amount is placed for example 150.

D is the difference between each week. i.e C3 and C4 , C4 and C5 and so on.

Above these two colums is a merged cell of C & D giving me the sum of the
total loss of Column D

What the problem is that because next week for example has no data in Col C,
Col D gives me the difference between this week and next week of 150 instead
of 0 because there is no data for next week.

Can some one tell me how to overcome this wee snag?

Cheers in advance guys

Anticipate the missing data.

Instead of a formula like:

=C4-C3

use

=IF(C4="","",C4-C3)
--
Gary''s Student - gsnu200732


"Andy Sibbs" wrote:

Hi guys, I am in need of a wee hand.

I have 2 columns, C & D.

C is a weekly column where an amount is placed for example 150.

D is the difference between each week. i.e C3 and C4 , C4 and C5 and so on.

Above these two colums is a merged cell of C & D giving me the sum of the
total loss of Column D

What the problem is that because next week for example has no data in Col C,
Col D gives me the difference between this week and next week of 150 instead
of 0 because there is no data for next week.

Can some one tell me how to overcome this wee snag?

Cheers in advance guys

You probably need to wrap your formula in an IF statement...........post
your formula, someone will help.

Vaya con Dios,
Chuck, CABGx3


"Andy Sibbs" wrote in message
...
Hi guys, I am in need of a wee hand.

I have 2 columns, C & D.

C is a weekly column where an amount is placed for example 150.

D is the difference between each week. i.e C3 and C4 , C4 and C5 and so
on.

Above these two colums is a merged cell of C & D giving me the sum of the
total loss of Column D

What the problem is that because next week for example has no data in Col
C,
Col D gives me the difference between this week and next week of 150
instead
of 0 because there is no data for next week.

Can some one tell me how to overcome this wee snag?

Cheers in advance guys

Something like:

=IF(C4="",0,C4-C3) and drag down column D

Regards

Trevor


"Andy Sibbs" wrote in message
...
Hi guys, I am in need of a wee hand.

I have 2 columns, C & D.

C is a weekly column where an amount is placed for example 150.

D is the difference between each week. i.e C3 and C4 , C4 and C5 and so
on.

Above these two colums is a merged cell of C & D giving me the sum of the
total loss of Column D

What the problem is that because next week for example has no data in Col
C,
Col D gives me the difference between this week and next week of 150
instead
of 0 because there is no data for next week.

Can some one tell me how to overcome this wee snag?

Cheers in advance guys

Top class, works a treat. Thank you

"Gary''s Student" wrote:

Anticipate the missing data.

Instead of a formula like:

=C4-C3

use

=IF(C4="","",C4-C3)
--
Gary''s Student - gsnu200732


"Andy Sibbs" wrote:

Hi guys, I am in need of a wee hand.

I have 2 columns, C & D.

C is a weekly column where an amount is placed for example 150.

D is the difference between each week. i.e C3 and C4 , C4 and C5 and so on.

Above these two colums is a merged cell of C & D giving me the sum of the
total loss of Column D

What the problem is that because next week for example has no data in Col C,
Col D gives me the difference between this week and next week of 150 instead
of 0 because there is no data for next week.

Can some one tell me how to overcome this wee snag?

Cheers in advance guys