# Multiplication Problem

#### segran

##### Active Member
Hi,

When a fraction is multilpied to an array of numbers, i want the results of the whole numbers only. Please see example below. Is there a way of doing this in a simple manner (macro/function)

Thank you

Excel Workbook
BCDEFGHI
2Data Set 1211299729*
3Data Set 2251721191428*
4********
5Fractions*******
6*1/2*******
7*2/3*******
8*1/7*******
9*6/7*******
1013/21*******
11********
12Example*******
13Using 1/2*1 * * *5 *1/214 *1/24 *1/23 *1/214 *1/2
14**12 *1/28 *1/210 *1/29 *1/27 * * *14 * * *
15********
16********
17**1*****
18******714
19********
20********
21**Result is 1, 7, 14*****
Sheet1

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### milesUK

##### Active Member
segran,

one way is to hide the results by Conditionally Formating the cells with a formula like:
Code:
``=C4<>INT(C4)``
However if you want cell D21 to read "Result is 1, 7, 14" for example then that is more work. Try this in cell D21:

Code:
``="The Result is "&SUBSTITUTE(D17&", "&E17&", "&F17&", "&G17,", *","")``
but replace D17&", "&E17&", "&F17&", "&G17 with the full set of cells making up your array.

Replies
7
Views
199
Replies
33
Views
614
Replies
8
Views
227
Replies
2
Views
45
Replies
2
Views
303

1,133,038
Messages
5,656,525
Members
418,312
Latest member

### 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