If statement with lots of variables

		Microsoft Office Forums > Microsoft Excel > Excel
If statement with lots of variables

FAQ

Thread Tools

Display Modes

02-07-2014, 12:52 PM

Pecoflyer

Windows 7 64bit If statement with lots of variables

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

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(),""))))

in F2 and pull down as needed

__________________
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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:27 AM.