Multiply If

[joestewart85]

Hi all - first post so please be kind!

I'm trying to produce an excel formula (ideally not in VBA) to enable me to undertake a "Multiply IF" (if that is even a thing?!) type function on a series of data

Column A will include a total cost
Columns B-T will include a liability % against a number of different, see example below

A B C D ............................................
20 50% 100% 0%
40 100% 100% 100%
F 50 60 40

The range of data runs for approximately 200 rows.

Ideally I'm looking for a formula which I include at the bottom of B-T which multiplies any cell with a percentage by the total cost expressed in the same row. This will hopefully include a sum of all items. I know I could include another column but I'm trying to avoid this if possible.

Thanks!

 

[petertenthije]

{=sum($A1:$A2*B1:B2)}

Don't type the {} brackets. You have to enter the formula with ctrl-shift-enter, instead of with enter to get the {}.

 

[joestewart85]

Thanks!!!!