Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2015, 04:40 PM
Lkh1004 Lkh1004 is offline IF Statement Windows 8 IF Statement Office 2013
Novice
IF Statement
 
Join Date: Dec 2015
Posts: 2
Lkh1004 is on a distinguished road
Default IF Statement

I am trying to do an IF statement. I have a date in cell I3 (example 12/9/2015) and a date in cell F4 (example 1/8/16). In cell I4 I want a formula that states if F4 is greater than I3 copy cell H4 to cell I4. Is this possible and what would the statement be? Thank you
Reply With Quote
  #2  
Old 12-15-2015, 06:47 PM
macropod's Avatar
macropod macropod is offline IF Statement Windows 7 64bit IF Statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,230
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

In I4:
IF(F4>I3,H4,"")
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-16-2015, 06:31 AM
Lkh1004 Lkh1004 is offline IF Statement Windows 8 IF Statement Office 2013
Novice
IF Statement
 
Join Date: Dec 2015
Posts: 2
Lkh1004 is on a distinguished road
Default

Thank you. That worked. Is it also possible to do the statement a between statement, for example if f4 (2/3/16) is between I3 ((12/27/15 - (1/23/16) copy h4 and if false add a "0" to I4? Appreciate the help.
Reply With Quote
  #4  
Old 12-16-2015, 02:47 PM
macropod's Avatar
macropod macropod is offline IF Statement Windows 7 64bit IF Statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,230
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Where are the two dates you want to compare stored? One is apparently in I3, but where is the other (or is it calculated from the value in I3)?

As for inserting a 0, simply change:
IF(F4>I3,H4,"")
to:
IF(F4>I3,H4,0)

Note: This is all very basic Excel stuff. I suggest you read a book on using Excel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statement Need a little help with an if statement cangelis Excel 2 04-08-2015 05:55 PM
IF Statement IF Statement teza2k06 Excel 1 03-11-2015 12:44 AM
IF Statement If statement, may be? Tony Singh Excel 6 03-04-2015 12:52 PM
Add a statement sma Word 6 03-23-2014 10:30 AM
IF Statement Need help with If, Then Statement Please cangelis Excel 4 01-03-2014 09:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:02 PM.


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