|
|
#1
02-07-2014, 08:19 AM
|
|||
|
|||
If statement with lots of variables
I am getting better with these if statements, this one is causes my brain to come to a screeching halt. I have a sheet that could contain 2 dates on the same row. I need to calculate the number of days remaining depending on what is in the blocks. I have attached a sample sheet for reference 
|
|
#2
02-07-2014, 12:52 PM
|
||||
|
||||
|
The following seems to be doning the trick
Code:
=IF(AND(C2>B2,B2>0),MAX(B2:C2)-TODAY(),IF(AND(B2="",C2=""),"N/A",IF(OR(C2="",B2=""),(C2+B2)-TODAY(),IF(C2=B2,C2-TODAY(),""))))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MS Office 2013 error (lots of errors) | Mr.Weck | Office | 8 | 01-04-2014 02:12 PM |
| Delete lots of empty space between paragraphs. | FieldTechnician | Word | 4 | 10-25-2013 01:14 PM |
 Please help! lots of errors
|
tundrawolf | Office | 7 | 04-24-2012 08:50 PM |
|
.pst File Missing Emails...lots
|
jamepc | Outlook | 1 | 07-12-2011 07:18 AM |
|
Lots of overlapping appointments!
|
MushyPeas | Outlook | 2 | 01-21-2009 10:01 AM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
