I would like to enter a formula into one cell that says:
if B24 = "White" and B19= "White" then £12. If B24= "White" and B19= "Black" then £20. If B24="White" and B19= "Gold" then £25. If B24= "Gold" and B19= "Gold" then £12. if B24= "Gold" and B19 = "White" then £16 etc etc.
Is this possible?
Bookmarks