Excel (2007) formula help needed

  tonyq 30 Sep 12
Locked
Answered

Please can anyone help me with formula I need for the following example [12.8 + 69 – (34 x2)] / 2 I will have a number of different numbers,and the result rounded up from .5 and above, rounded down below .5

  mgmcc 30 Sep 12

Try:

=ROUND((12.8+69-(34*2))/2,0)

This gives the answer 7 and the final zero sets the number of decimal places to display.

  tonyq 30 Sep 12

mgmcc, thank you that seems to work. Next question,how do I get it to work on a list of numbers?

  mgmcc 30 Sep 12
Answer

In general, have the list of numbers in a separate column and replace the "number" in the formula with the cell reference of the number it has to work with. For example, if it is the 12.8 it has to work with, put that in cell A1 and make the formula:

=ROUND((A1+69-(34*2))/2,0)

  tonyq 30 Sep 12

mgmcc thank you for your help advice.

Advertisement

This thread is now locked and can not be replied to.

Windows 10 Home vs Windows 10 Pro comparison: Here are the extra features you get in the Pro version

Behind the scenes at Silverstone, the 70th British Grand Prix: Hisense starts UK push with Red…

How Found created this skateboard, bike and parkour stunts-laden, single-take car ad

Apple Pay UK launch date, UK user guide and participating UK banks | Apple Pay to launch in UK on 1?…

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message