Hi, I have an IF Function to return a particular value - like below
=IF(E7="perspex - bolts","L/E","")
But I need it to also look in column J and return L/E if the criteria = High End, so logically I thought something like this
=IF(E7="perspex - bolts","L/E","")+=IF(J7="High - End","L/E","")ORJ7="Mid - range","L/E","")
Obviously it isn;t this
So I only want it to return the "L/E" if the crriteria in columns E and J = "Perspex-bolts" AND "High-End" or "Mid-range
What formula would I need to achieve this?
Thanks
Bookmarks