Multiple If Statement with number range

ramosca

New Member
Joined
Mar 5, 2012
Messages
17
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!! :smile:
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top