Results 1 to 9 of 9

Problem solving complex if/and/or formula

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    Springfield, MO
    MS-Off Ver
    Excel 2007
    Posts
    6

    Problem solving complex if/and/or formula

    I am having difficulties coming up with a formula to solve the following criteria... please help!!!

    1 point for K2=A OR K2=B OR K2=C OR K2=D
    1 point for L2>139 OR M2>89 (if both, still only add 1 point)
    1 point for N2>149 OR R2<40 OR S2>99 OR T2>199 (if one or more, still only add 1 point)
    1 point for O2>125 OR O2 has red font
    1 point for W2>26 IF (Q2>1.0 if D2=M OR Q2>0.8 if D2=F)

    I need all the points to add up in X2.
    Attached Files Attached Files
    Last edited by dab37843; 09-12-2012 at 10:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1