|
|
#4
03-30-2017, 12:12 AM
|
|||
|
|||
Equation still not working
Unfortunately, my equation still does not work, please see the attached image.
It is calculating the negative hours OK, but it is showing the positive variations as negative? I have marked the cells which should be positives in yellow. I have tried the basic Total2 - Total but this does not show the negative results. Any help would be great. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 6 (or 7) Nested IFs!
|
JuicyHMouse | Excel | 1 | 03-11-2017 06:41 AM |
| nested formula using IF & AND | paxon | Excel | 3 | 02-18-2016 05:32 AM |
|
Nested IF
|
TDWolsey | Excel | 2 | 01-06-2016 11:31 PM |
|
Adding rows and copying formulas
|
ejtoll | Word Tables | 1 | 12-05-2012 05:09 PM |
|
Nested IFs
|
JimS378 | Excel | 7 | 05-03-2011 08:20 PM |
Windows 8 
Office 2013
Threaded Mode