Thread: Holiday report excel - pull +/- hours from cells containing text and number
View Single Post
 
Old 12-09-2016, 06:00 AM
bobby123456789 bobby123456789 is offline Windows 10 Office 2013
Novice
  
Join Date: Dec 2016
Posts: 2
bobby123456789 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Holiday Excel.xlsx (10.2 KB, 10 views)
Reply With Quote