Multiplication Problem

segran

Active Member
Joined
Aug 20, 2004
Messages
335
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
Joined
Jan 5, 2003
Messages
388
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.
 

Watch MrExcel Video

Forum statistics

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

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top