# 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

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### 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
249
Replies
33
Views
849
Replies
8
Views
262
Replies
2
Views
59
Replies
2
Views
346

1,136,954
Messages
5,678,759
Members
419,782
Latest member
gc75150

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