Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 12
Default Help with complex IF statement

Hi everyone, I hope you can help?

I currently have the below, which either gives me "Not in Use", "Open", "Hit PDD Within 5 Days" or "Missed PDD Over 5 Days" as possible results.

=IF(B2="","Not in Use",IF(E2="","Open",IF(I2<=5,"Hit PDD Within 5 Days",IF(I2=6,"Missed PDD Over 5 Days"))))

Now what I'd like to be able to do is then say if E2 does in fact turn out to be "Open", then do another calculation on it to split it down even further so I could have 5 possible results ("Not in Use", "Open Within Limit", "Open Missed Limit", "Hit PDD Within 5 Days" or "Missed PDD Over 5 Days")

For anything with a result of Open I'd like it to check if F2 is greater than -5 (in which case it would be "Open Missed Limit", if it's less then -5 then "Open Within Limit".

I hope this all makes sense as I'm confusing myself now

Thanks so much in advance, you guys have been so so helpful and I'm learning a lot (keeping this in my bookmarks for future reference
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Help with complex IF statement

Hi,

Am Wed, 3 Oct 2012 08:45:27 +0000 schrieb D4WNO:

=IF(B2="","Not in Use",IF(E2="","Open",IF(I2<=5,"Hit PDD Within 5
Days",IF(I2=6,"Missed PDD Over 5 Days"))))

Now what I'd like to be able to do is then say if E2 does in fact turn
out to be "Open", then do another calculation on it to split it down
even further so I could have 5 possible results ("Not in Use", "Open
Within Limit", "Open Missed Limit", "Hit PDD Within 5 Days" or "Missed
PDD Over 5 Days")

For anything with a result of Open I'd like it to check if F2 is greater
than -5 (in which case it would be "Open Missed Limit", if it's less
then -5 then "Open Within Limit".


try:
=IF(B2="","Not in Use",IF(AND(E2="",F2-5),"Open Missed Limit",IF(AND(E2="",F2<-5),"Open Within Limit",IF(I2<=5,"Hit PDD Within 5 Days",IF(I25,"Missed PDD Over 5 Days")))))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex IF Statement Jonni Excel Discussion (Misc queries) 7 June 26th 09 04:09 PM
Complex If/And Statement jonssmaster Excel Worksheet Functions 8 December 1st 08 08:27 PM
Complex IF statement cathy Excel Programming 7 October 15th 07 07:26 PM
complex IF statement cathy Excel Programming 5 September 21st 07 08:34 PM
complex IF(OR(...AND())) statement Dave F Excel Discussion (Misc queries) 2 October 4th 06 06:24 PM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"