How do I set If Statement to set Priorities, off of dates due?

I am trying to set up If Statements to read dates for several projects and
from those dates set priority levels of A, B, C, etc... Can anyone offer
assistance?

Try something like:

=IF(B1=DATE(2005,1,1),"A",IF(B1=DATE(2005,1,2),"B","C"))

----
Regards,
John Mansfield
http://www.pdbook.com

"K Svoboda" wrote:

> I am trying to set up If Statements to read dates for several projects and
> from those dates set priority levels of A, B, C, etc... Can anyone offer
> assistance?

One way:

assuming the due date in A1:

=IF((A1-TODAY())<=0,"HOT",IF((A1-TODAY())=1,"Short-Term","Long-Term"))


In article <[email protected]>,
K Svoboda <K [email protected]> wrote:

> I am trying to set up If Statements to read dates for several projects and
> from those dates set priority levels of A, B, C, etc... Can anyone offer
> assistance?

If you have more than 3 levels you might want to consider a vlookup table

=VLOOKUP(B1,F3:G8,2)

where for instance F3:F8 would hold the dates and G3:G8 the priority levels
where the table might look like

1/1/2005 A
1/2/2005 B
1/3/2005 C
1/4/2005 D
1/5/2005 E

Regards,

Peo Sjoblom


"K Svoboda" wrote:

> I am trying to set up If Statements to read dates for several projects and
> from those dates set priority levels of A, B, C, etc... Can anyone offer
> assistance?

Is there an easy way if you are looking at 30 different projects over the year?

"John Mansfield" wrote:

> Try something like:
>
> =IF(B1=DATE(2005,1,1),"A",IF(B1=DATE(2005,1,2),"B","C"))
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
> "K Svoboda" wrote:
>
> > I am trying to set up If Statements to read dates for several projects and
> > from those dates set priority levels of A, B, C, etc... Can anyone offer
> > assistance?

how i calculate the everyday meter reading in the excel sheet. I am not able to calculate. Pl guide me how i calculate with example in the excel sheet. I have only one meter