Function to ignore decimals

  • Thread starter Thread starter Poliisi
  • Start date Start date
P

Poliisi

How can i create simple math function from chart location, which ignores
its decimal numbers?

Ie. A2 is "=1/2" and A1 is "=A2 * 2". I want the A1 function to display 0
as it would if the outcome from A2 is not rounded and the decimals are
simply dropped away.
 
How can i create simple math function from chart location, which ignores
its decimal numbers?

Ie. A2 is "=1/2" and A1 is "=A2 * 2". I want the A1 function to display 0
as it would if the outcome from A2 is not rounded and the decimals are
simply dropped away.
Click to expand...

A1: =INT(A2)*2


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addition errors with Decimal Places 5
using the "&" function 2
if statement 3
Showing 0 after decimal with ROUND 5
the decimals extends after the sum function 2
Getting an ActiveX command button to do a spreadsheet function 4
Determine decimal 5
excel 2003 zero as last decimal 5

Back
Top