IF Function

Azleenda · #1 11-05-2015, 01:47 AM

Hi, I would like to know if i can add another formula (add on) to below function i'm currently using.

For example a date is entered on A09 cell, the next cell A10 will reflect either 'Open' or 'Closed' by using this formula =IF(AO9="","Open","Closed").

Now beside this, I also need to know if I can add another formula next to it.
Cell A09 requires a date to be entered in order to know my document is Open or Closed, but by 7 days if there isn't any date entered i want my cell A10 to show 'Due' by number of days.

Great if anyone can help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What function would do this?	namedujour	Excel	3	09-14-2015 07:15 PM
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM
IF function	msheyworth	Excel	2	03-28-2013 02:15 AM
Sum Function	teza2k06	Excel	3	02-06-2013 08:29 AM