Forum Discussion
Formula help
I have a spreadsheet with 3 sets of 2 columns and endless rows. The first column will be one of 3 letter codes. The second column will be a number expressed in whole numbers and digits following a fu...
=SUMPRODUCT((A4:C4="X")*((B4:C4*0.2)+0.1), (A4:C4="Y")*((B4:C4*0.4)+0.15), (A4:C4="Z")*((B4:C4*0.6)+0.25))