IF Statement

		Microsoft Office Forums > Microsoft Excel > Excel
IF Statement

FAQ

Thread Tools

Display Modes

12-16-2015, 02:47 PM

macropod

Windows 7 64bit IF Statement

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,340

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]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a little help with an if statement	cangelis	Excel	2	04-08-2015 05:55 PM
IF Statement	teza2k06	Excel	1	03-11-2015 12:44 AM
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
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 08:37 AM.