Excel (2007) formula help needed

  tonyq 13:32 30 Sep 2012
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 13:46 30 Sep 2012

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 14:11 30 Sep 2012

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

  mgmcc 14:56 30 Sep 2012
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 15:03 30 Sep 2012

mgmcc thank you for your help advice.

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

Elsewhere on IDG sites

Nokia 8 vs Galaxy S8

Best new design books 2017: From vintage infographics to the the psychology of type

iMac 21.5-inch (2017) review

Nokia 8 : design, caractéristiques techniques, date de sortie