• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combining five different type of condition

Ed Khoo

New Member
Good day, I have failed to combine the function according to below condition. Anyone who can help me in this? Appreciates. Thank you

if(B9&D9="","-")-main

if(B9&C9&D9&E9="<>",E9)
if(B9&C9&D9="<>",G9)

if(D9&E9&F9&G9="<>",G9)
if(D9&E9&F9="<>",G10)
 

Hui

Excel Ninja
Staff member
=if(B9&D9="","-", if(B9&C9&D9&E9="<>",E9, if(or(B9&C9&D9="<>", D9&E9&F9&G9="<>"),G9, if(D9&E9&F9="<>",G10, 1, 0)
 
Top