Thread: [Solved] I cant get my Sum(Offset formula to pull appropriate data.
View Single Post
 
Old 07-28-2016, 10:46 AM
Erickd90 Erickd90 is offline Windows 10 Office 2016
Novice
  
Join Date: Jul 2016
Posts: 4
Erickd90 is on a distinguished road
Default
What I want to do is take B19 from the sales tab and multiply that by the number in F4 on my Breakeven tab.

If f4 on the Breakeven tab lists 0 or is empty, I need it to list the value of B19 on the sales tab.

Example...

Breakeven!F4 = 0

Sales!B19 = 1000

Breakeven!B19 = 1000


If Breakeven!F4 is changed to 1....

Breakeven!F4 = 1

Sales!B19 = 1000

Breakeven!B19 = 2000

If we change Breakeven!F4 to 5

Breakeven!F4 = 5

Sales!B19 = 1000

Breakeven!B19 = 5000
Reply With Quote