|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
12-09-2016, 06:00 AM
|
|||
|
|||
Holiday report excel - pull +/- hours from cells containing text and number
I am looking to breakdown the report as per the attachment.
Any input with Sold I want to make a minus of the figure stated. Any input with Bought I want to make a positive of the figure stated. Any with "not a member" I want to make a 0. Does anyone know a formula for this? Thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pull data from Excel to Powerpoint (not dynamically) | Terri11130 | PowerPoint | 1 | 08-25-2015 12:17 PM |
| Method for populating report text from a library of text. | daj | Word | 1 | 03-18-2015 08:57 AM |
| Copying and pasting acount data into Excel as text will not reformat to a number or currency | ncbergst | Excel | 3 | 09-04-2014 11:29 AM |
 Read text Report file with VBA and write parsed fields to Excel workbook
|
tpcervelo | Excel Programming | 1 | 01-05-2012 10:14 PM |
| Excel VBA: Pull data from web | tinfanide | Excel Programming | 0 | 12-09-2011 02:11 AM |
Windows 10 
Office 2013
Threaded Mode