# Multiply If

#### joestewart85

##### New Member
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!

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

#### petertenthije

##### Board Regular
{=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 {}.

Thanks!!!!

Replies
2
Views
71
Replies
2
Views
76
Replies
1
Views
133
Replies
0
Views
61
Replies
3
Views
279

1,127,462
Messages
5,624,871
Members
416,063
Latest member
chaulon199

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back