Multiple If Statement with number range

[ramosca]

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!!

 

[Jonmo1]

Try

=IF(A2<0,"Error",IF(A2>=16,"NO",IF(ISNUMBER(D2),"YES","Pending")))

 

[ramosca]

Thank you so much, this is exactly what I needed.