MrExcel Message Board


Go Back   MrExcel Message Board > Question Forums > Excel Questions

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old Mar 30th, 2004, 08:41 AM   #1
dougie
 
Join Date: Mar 2004
Posts: 45
Default HELP WITH NESTED STATEMENTS

HELP.....

I have a query that requires FOUR possible answers depending on the data contained within a cell.


I have FOUR columns. The STATUS column being where i want the formula to be.

DATE ACCEPTED, DATE AUTHORISED, DATE RECEIVED, STATUS.

What I am trying to achieve is:

1: If DATE AUTHORISED cell is NULL after five days from DATE ACCEPTED cell, then give me a message to say "Chase Authorising Officer" once date entered into DATE AUTHORISED cell say "AUTHORISED"

Then,

2: Once DATE AUTHORISED has been entered and DATE RECEIVED cell is NULL after 5 days give a message to say "CHASE ME" once date entered into DATE RECEIVED cell say "COMPLETE".

I dont know if it can be done, but I will be extremely gratefull for the time giving in solving this nightmare for me.

Many thanks in anticipation.

Dougie
[/img][/url][/list][/code]
dougie is offline   Reply With Quote
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT +1. The time now is 09:12 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All contents Copyright 1998-2009 by MrExcel Consulting.