1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel forumula

Discussion in 'Microsoft Office Specialist (MOS)' started by Nelix, Dec 18, 2007.

  1. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    Hello All....Long time no post.

    I have a user/customer that has 4 formula's in different cells in an excel spreadsheet, he has asked if they can be combined into a single formula.

    I know it can be done as I have seen and used something similar however I'm no excel expert

    The 4 formulas are as follws:

    1. =IF(L9>=50%,IF(M9>=50%,"Good and Expensive"),"NA")
    2. =IF(L12<50%,IF(M12>=50%,"Good and Cheap"),"NA")
    3. =IF(L15<50%,IF(M15<50%,"Poor and Cheap"),"NA")
    4. =IF(L18>=50%,IF(M18<50%,"Poor and Expensive"),"NA")
    Any help would be greatly appreciated, If you need anymore info just shout

    Cheers
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  2. DiscoPistol

    DiscoPistol Bit Poster

    13
    0
    9
    Try this

    =IF(AND(L9>50,M9>50)= TRUE, "Good and Expensive",IF(AND(L9<50,M9<50)= TRUE,"Poor and Cheap",IF(AND(L9>50,M9<50)= TRUE,"Poor and Expensive","Good and Cheap")))

    DP
     
    WIP: MOS Master
  3. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    Hi

    Thanks for the help, and welcome to the forums.

    I used your formula as a base, amended it and ended up with this

    =IF(AND(L9>=50%,M9>=50%)= TRUE, "Good and Expensive",IF(AND(L9<=49%,M9>=50%)= TRUE,"Good and Cheap",IF(AND(L9>=50%,M9<=49%)= TRUE,"Poor and Expensive",IF(AND(L9<=49%,M9<=49%)= TRUE,"Poor and Cheap","N/A"))))

    thanks again
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294

Share This Page

Loading...