Hello everyone I've encountered a problem that I cannot figure out. How can I correct the problem I'm having. What I'm trying to achieve is a calculation for cell H10 using nested IF statements. If C10 & A2 match and there is a price in cell C2 then the price will show in H10, but if there is no price in C2 then H10 will show the value calculated from G10*45*24. So far this is working but my problem is if I select a different selection available in C10 and match it with lets say A3 then nothing happens. Can anyone guide me through this problem. Thanks. I have attached a working test file.
Bookmarks