Results 1 to 10 of 11

Thread: Nested If Formula With Multiple Conditions

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Apr 2013
    Posts
    3
    Rep Power
    0

    Nested If Formula With Multiple Conditions

    Hello!
    Please, can someone tell me how can I make formula for:
    If D2 ; E2 ; F2 >= 4 and G2 >=5 , than H2 = 18, but IF D2 ; E2 ; F2 >= 4 and G2 >=7 , that H2 = 27. If any of these numbers are less than the condition, than H2 = 0 .

    That would be unspeakably helpful for me !
    Attached Images Attached Images

Similar Threads

  1. Replies: 4
    Last Post: 03-22-2013, 01:47 PM
  2. Nested Search Function Excel Formula
    By trankim in forum Excel Help
    Replies: 6
    Last Post: 10-29-2012, 10:29 PM
  3. Replies: 11
    Last Post: 10-07-2012, 12:05 AM
  4. Excel Nested IF Function With 3 Conditions
    By patsir in forum Excel Help
    Replies: 3
    Last Post: 08-25-2012, 07:15 PM
  5. Excel Nested IF 3 Condition Formula
    By yomgi in forum Excel Help
    Replies: 2
    Last Post: 02-20-2012, 11:50 PM

Posting Permissions

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