| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
1.23 return to 0.23
Hello I input 1.23 in A1 but I want B1 to return to 0.23 How can I do that?  Thanks! -- swwong ------------------------------------------------------------------------ swwong's Profile: http://www.excelforum.com/member.php...o&userid=23963 View this thread: http://www.excelforum.com/showthread...hreadid=375861 |
|
#2
|
|||
|
|||
|
enter in B1 =A1-1 Stuart -- wa284sj ------------------------------------------------------------------------ wa284sj's Profile: http://www.excelforum.com/member.php...o&userid=22941 View this thread: http://www.excelforum.com/showthread...hreadid=375861 |
|
#3
|
|||
|
|||
|
I mean 1.23 return to 0.23 or 2.12 return to 0.12. or 10000.1 return to 0.1 Thanks -- swwong ------------------------------------------------------------------------ swwong's Profile: http://www.excelforum.com/member.php...o&userid=23963 View this thread: http://www.excelforum.com/showthread...hreadid=375861 |
|
#4
|
|||
|
|||
|
In B1 =a1-int(a1) -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=375861 |
|
#5
|
|||
|
|||
|
=MOD(A1,1)
-- Regards, Peo Sjoblom (No private emails please) "swwong" wrote in message ... I mean 1.23 return to 0.23 or 2.12 return to 0.12. or 10000.1 return to 0.1 Thanks -- swwong ------------------------------------------------------------------------ swwong's Profile: http://www.excelforum.com/member.php...o&userid=23963 View this thread: http://www.excelforum.com/showthread...hreadid=375861 |
|
#6
|
|||
|
|||
|
plus, if you wish to allow for negative numbers: =IF(A1<0,A1+(INT(A1)*-1)-1,A1-INT(A1)) or =IF(A1<0,MOD(A1,-1),MOD(A1,1)) -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=375861 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| How to return # characters based on 2nd instance of value | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| How do I return dynamic lists? | Excel Worksheet Functions | |||
Linear Mode
