Make a decimal number return to zero

mikerickson mikerickson is offline

Junior Member

Location: Winters CA

Posts: 22

Quote:

Originally Posted by

I am looking to make a decimal number return to zero. Example

if AI EQUALS 37.5

I want to do a formula that divides AI by 2 and when it comes out to 18.75 which is not a whole number then it should state the cell as zero if it is a whole number then it would return the whole number to that cell.

I'm not sure if you are looking for =INT(A1/2)

or =(A1/2)*(1-SIGN(MOD(A1/2,1))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
make excel automatically add a decimal	Darrell Eddy	Excel Worksheet Functions	1	March 20th 08 05:32 PM
how to make value whole (remove decimal point)	Roger	Excel Worksheet Functions	1	July 18th 07 11:20 PM
Converting 2-place decimal value to floating point decimal number with leading zero	Kermit Piper	Excel Discussion (Misc queries)	3	March 18th 06 06:20 PM
Make divisions and display no decimal value at the quotient!	FreakyShadow	Excel Discussion (Misc queries)	2	March 5th 06 05:28 AM
How to convert a decimal number to a non-decimal number?	snickers22	Excel Worksheet Functions	4	January 13th 05 10:04 PM

All times are GMT +1. The time now is 07:44 AM.

Menu

About Us