Hi, I am trying to enter a multiple if statment and having a little bit of trouble.
I am working with Windows XP Prefessional and Excel 2007
My report is looking for formula on weather the goal has been met.
The goal met column (A2) has figures that range from -257 to 114.
I need a formula that shows the following results:
if cell A2 is less than zero the result should be ERROR
if cell A2 is less than or equal to 15 days and there is no date in cell D2 the result should be PENDING
if cell A2 is less than or equal to 15 days and there is a date in cell D2 the result should be YES
if cell A2 is 16 days and over the result should be NO
So my formula is based on 2 things
1. the number of days listed in cell A2
2. if there is a date listed in cell D2
Again any help would be greatly appreciated!!
I am working with Windows XP Prefessional and Excel 2007
My report is looking for formula on weather the goal has been met.
The goal met column (A2) has figures that range from -257 to 114.
I need a formula that shows the following results:
if cell A2 is less than zero the result should be ERROR
if cell A2 is less than or equal to 15 days and there is no date in cell D2 the result should be PENDING
if cell A2 is less than or equal to 15 days and there is a date in cell D2 the result should be YES
if cell A2 is 16 days and over the result should be NO
So my formula is based on 2 things
1. the number of days listed in cell A2
2. if there is a date listed in cell D2
Again any help would be greatly appreciated!!
