Home

Welcome to OnlineConversion.com

Excel Calculation
 

Excel Calculation
by Bryant Robinson on 05/25/05 at 16:27:07

I'm trying to apply the following formula into Excel.

E4-f4=-/E4=G4

ex. 112-12=100 -/112=0.892857142857

In the above example the finished result should be 89 without any additional
numeric value. Is there anyway to display this result in Excel?

Thanks in advance!


Re: Excel Calculation
by Robert Fogt on 05/25/05 at 18:38:46

I used the following formula:

=INT(((E4-F4)/E4)*100)

If cell E4 contains 112 and cell F4 contains 12, then the cell with the formula will contain 89.

Now the problem is the INT function I used, it just drops all after the decimal place, which is what I guess you asked for. It does not round. For example, if the number is 89.9 and you want to round up to 90, you need to use the ROUND function, not the INT function like I used.

Here is using the round function:

=ROUND(((E4-F4)/E4)*100,0)

Using INT it just drops the decimal, using ROUND it rounds the decimal.


Go Back | Archive Index


 

Did you find us useful?

Please consider supporting the site with a small donation.

click here for more information

 


BookMark Us

It may come in handy.

Check out our Conversion Software for Windows.

Can't find something?
Try searching.

Are you bored?
Try the Fun Stuff.

Was this site helpful?
Link to Us | Donate