Excel forumula

Nelix · #1 18-Dec-2007, 10:39 AM

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:

=IF(L9>=50%,IF(M9>=50%,"Good and Expensive"),"NA")
=IF(L12<50%,IF(M12>=50%,"Good and Cheap"),"NA")
=IF(L15<50%,IF(M15<50%,"Poor and Cheap"),"NA")
=IF(L18>=50%,IF(M18<50%,"Poor and Expensive"),"NA")

Any help would be greatly appreciated, If you need anymore info just shout

Cheers

DiscoPistol · #2 18-Dec-2007, 12:19 PM

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

Nelix · #3 19-Dec-2007, 10:38 AM

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