Could someone please guide me as to what the best was is to achieve my formula - IF or Sumproduct.
I have atatched the spreadsheet and the desired result in Cell Q16.
The answer should be 73,906. Cell Q15 should be zero and for example Cell Q25 should be 33,529 x 0.9
Any help would be greatly appreciated.
Thanks
Bookmarks