|
|
#3
12-11-2016, 02:10 AM
|
|||
|
|||
You can do this:
C2 = IF(OR(A2="",B2=""),"",SUM(A2:B2)) A3 = IF(C2="","",C2) then you just copy the formula down. P.S. I would personally avoid using IF for trivial condition like that since it can get messy when you nest an IF inside another IF, but this one seems simple enough. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using alternating borders in adjacent cells | jrevard | Word | 0 | 10-15-2015 09:07 AM |
| How do I separate an address into separate cells | Austcart | Excel | 2 | 01-18-2015 03:48 PM |
 How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?
|
alshcover | Excel | 2 | 06-03-2014 12:50 PM |
|
Word Macro to find and delete rows that contain adjacent cells containing "."
|
AlexanderJohnWilley | Word VBA | 7 | 11-08-2012 10:15 AM |
| How to "hard link" two adjacent cells to a data validation drop down list? | Geza59 | Excel | 10 | 10-19-2012 11:56 AM |
Windows 10 
Office 2010 64bit
Threaded Mode