Microsoft Office Forums - View Single Post - [Solved] I cant get my Sum(Offset formula to pull appropriate data.

Thread: [Solved] I cant get my Sum(Offset formula to pull appropriate data.

View Single Post

Old

07-28-2016, 11:27 AM

Erickd90

Erickd90 is offline

Erickd90 uses Windows 10

Windows 10 Erickd90 uses Office 2016

Erickd90 uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jul 2016

Posts: 4

Erickd90 is on a distinguished road

Default

XOR,

The pattern would follow this...

0: 1000
1: 2000
2: 3000
4: 5000
5: 6000

I have used an IF statement to complete everything except I am not sure how to avoid the multiplying by 0...

Reply With Quote