|
|
#3
07-28-2016, 10:46 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 pull data using drop down menu
|
nfsmith | Excel | 8 | 03-23-2016 11:28 PM |
|
Data validation list filter with range defined by OFFSET
|
Mango123 | Excel | 4 | 03-18-2014 02:52 PM |
|
Syntax to use OFFSET() in a cell formula?
|
dlowrey | Excel | 3 | 07-09-2013 09:15 AM |
|
sumproduct formula to pull info from multiple sheets
|
Berk21 | Excel | 7 | 01-15-2012 11:41 AM |
| Excel VBA: Pull data from web | tinfanide | Excel Programming | 0 | 12-09-2011 02:11 AM |
Windows 10 
Office 2016
Threaded Mode