Multiple IF's ??

[duane_mi]

I am trying to calculate a date field but it looks like i will nee
multiple IF's can anyone give me a hand.
The columns i have are shown below i will always have a pending valu
(in a date/time format)for a request generated by the system. I want t
be able to calculate how long it has been pending to todays date. I wil
then break them down by open for 1 day, 5 days or 10 days. If any of th
other fields are populated the system will update them and i will nee
to subtract them from Pending to get a completed cancelled or authorise
time.

Cancelled¦Authorised¦Complete¦Inprogress¦Pending

 

[zvkmpw]

I am trying to calculate a date field but it looks like i will need

multiple IF's can anyone give me a hand.
The columns i have are shown below i will always have a pending value
(in a date/time format)for a request generated by the system. I want to
be able to calculate how long it has been pending to todays date. I will
then break them down by open for 1 day, 5 days or 10 days. If any of the
other fields are populated the system will update them and i will need
to subtract them from Pending to get a completed cancelled or authorised
time.

Cancelled�Authorised�Complete�Inprogress�Pending�

Maybe this would help getting started, if I understand the requirement.

Put this in F2, copy down, and format as a number:
=IF(MAX(A2:C2)=0,TODAY(),MAX(A2:C2)) - E2
This would calculate either
- how long pending
or
- completed cancelled or authorised time,
depending on whether or not is has been completed, cancelled or authorised.

In another column, you could "break them down by open for ..."

 

[duane_mi]

Good idea on the sample here is a quick sample of the data normal
around 50000 rows but this should give you an idea of what i am tryin
to do.

Thank

+-------------------------------------------------------------------
|Filename: KPI Test.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=431
+-------------------------------------------------------------------