LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 79
Default IF Statments in Excel

I am trying to do an if statement and my data column has some fields that are
blank. The statment looks like this, =IF(M7<=J7,"ON TIME","LATE TO NEED TO
NEED"). My problem is when M7 is blank, I get a false true statment. How do
I get the value to return a false statement, instead?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If then Statments Tina Excel Worksheet Functions 5 January 20th 09 09:43 PM
If statments Lweiss Excel Worksheet Functions 2 March 20th 08 08:01 AM
AND OR IF Statments Rogie Excel Worksheet Functions 3 February 12th 07 04:01 AM
How many concurrent nested IF statments does Excel allow? Loudmouth Excel Discussion (Misc queries) 8 May 4th 06 10:04 PM
Is there an Excel template to reconcile business bank statments? Acct Rep Excel Discussion (Misc queries) 1 February 24th 05 08:04 AM


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"