Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page If statement with lots of variables If statement with lots of variables
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2014, 08:19 AM
bremen22 bremen22 is offline If statement with lots of variables Windows 7 64bit If statement with lots of variables Office 2010 64bit
Advanced Beginner
If statement with lots of variables 		 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Forum Sample Sheet.xlsx (12.8 KB, 15 views)
Reply With Quote
  #2  
Old 02-07-2014, 12:52 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If statement with lots of variables 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 reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
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
Reply With Quote
  #3  
Old 02-07-2014, 01:47 PM
bremen22 bremen22 is offline If statement with lots of variables Windows 7 64bit If statement with lots of variables Office 2010 64bit
Advanced Beginner
If statement with lots of variables 		 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Default
Excellent. thank you so much
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


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
If statement with lots of variables Please help! lots of errors tundrawolf Office 7 04-24-2012 08:50 PM
If statement with lots of variables .pst File Missing Emails...lots jamepc Outlook 1 07-12-2011 07:18 AM
If statement with lots of variables 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 10:25 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft