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: 11
Default multiple IF formulas

In A1, I have a date linked from another file worksheet. I used the If (is
blank) formula so no data appears unless there is a date to link from the
other worksheet.

In A2, I also have a date linked from another file worksheet. I also used
the If (is blank) formula so no data appears unless there is a date to link
from the other file worksheet.

I am trying to write a formula for Cell A3 that will return a given phrase
(i.e. past due) if the date in cell A2 is greater than the date A1. AND,
return a blank cell for A3 if there are no dates in cells A1 or A2.


 
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
Multiple formats in a single cell with multiple formulas Zakhary Excel Worksheet Functions 1 May 2nd 08 12:08 AM
multiple formulas in an IF inmelbvic Excel Worksheet Functions 4 December 11th 07 07:16 AM
Multiple-Value formulas EricB Excel Worksheet Functions 6 May 14th 07 01:26 PM
Sort multiple columns with multiple formulas without returning #R bellsjrb Excel Worksheet Functions 0 July 14th 06 10:01 AM
Multiple Formulas LCpl Shaw Excel Discussion (Misc queries) 1 October 4th 05 10:36 PM


All times are GMT +1. The time now is 01:53 AM.

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

About Us

"It's about Microsoft Excel"