|
|
#1
03-28-2017, 08:14 AM
|
|||
|
|||
Adding IF in nested formulas
Hi,
I have a formula calculating number of hours as follows: =TEXT(MAX([@Total2],[@Début])-MIN([@Total2],[@Début]),"-H::MM") I would like to add an If statement, saying that if cell ## returns a result of 0:00 (hrs) then leave the cell blank. How do I add this into the existing formula? Thanks Caz 
|
|
|
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