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:14 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

I don't understand your logic.

Breakeven!F4 = 1

Sales!B19 = 1000

Breakeven!B19 = 2000

and
If we change Breakeven!F4 to 5

Breakeven!F4 = 5

Sales!B19 = 1000

Breakeven!B19 = 5000

1: 2000
2: 3000
3: 4000
4: 5000
5: 6000

or what is the pattern?

Perhaps like the attached.

Attached Files

Breakeven Lyte_2.xlsx (22.2 KB, 10 views)

Reply With Quote