Excel forumula

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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

 

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