fractions in separate cell

C

cltdesigns

New Member
Joined
Oct 28, 2009
Messages
5
Hello, can someone please tell me how to handle this:
I want cell c4 to look at the number in cell c3, if it's not a whole number (for instance: 14.25) I would like the fraction (.25) to show in cell c4.
Thank you so much!
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
MrKowz

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Welcome to the forums!

Try:

=MOD(C3,1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

JenniferMurphy
  • Solved
When is an integer not an integer?
2
Replies
11
Views
396
JenniferMurphy
JenniferMurphy
A
  • Question
Sum of a value has to be limited to a plural of a fraction
Replies
3
Views
181
JamesCanale
JamesCanale
S
  • Question
Excel schedule with fraction of days
Replies
2
Views
863
Joe4
Joe4
O
  • Question
Counting multiple fractions, separated by commas, inside multiple cells, only if the number is larger than a certain threshold(80%)
Replies
8
Views
278
OBE
O
T
  • Locked
  • Question
Executing code to clear data in different cells and input words according to rules specified
Replies
1
Views
198
Fluff
Fluff

Forum statistics

Threads
1,191,204
Messages
5,985,263
Members
439,953
Latest member
suchitha

Share this page

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