LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 102
Default Combining 4 Conditions into 1 Formula!

I am trying to establish a formula to produce the following flags in Column Q:

Level 1 Program Completed
Level 1 Program Not Completed
Level 2 Program Completed
Level 2 Program Not Completed

The following are the conditions I am trying to set up for the formula, but
I need some help bringing it all together. I'm good at conceptualizing what I
need, but often not so good at my "ands" and my "ors", and my parenthesis.
The four conditions below should be expressed with one formula:

=IF(I4="1",AND(O4="Yes","Level 1 Program Completed")
=If(I4="1", AND(O4="No","Level 1 Program Not Completed")

=IF(I4="2",AND(O4="Yes",AND(P4<"","Level 2 Program Completed")
=If(I4="2",AND(O4="NO","Level 2 Program Not Completed")

Thank you very much for any help!
Best,

Dan





 
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
Combining IF, ANd and SUM functions in a formula RJanz Excel Worksheet Functions 13 January 4th 08 12:22 PM
Combining Text and formula Mitchell Excel Discussion (Misc queries) 3 December 11th 06 05:07 PM
Combining formula Wendy Excel Discussion (Misc queries) 6 November 20th 06 09:42 PM
Combining Text from multiple cells under multiple conditions KNS Excel Worksheet Functions 2 June 15th 05 11:00 PM
Combining conditions for data entry validation Richard H Knoff Excel Worksheet Functions 10 November 14th 04 01:49 PM


All times are GMT +1. The time now is 02:45 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"