Forum Discussion

jennhassibi's avatar
jennhassibi
Copper Contributor
Nov 27, 2017

Excel formulas

I have very little Excel experience, and am entirely dependent on a table created for me. I need the result of a formula rounded up, and I can't figure out how to add it to the current formula. Can someone please help me??

Formulas and Functions

3 Replies

  • jennhassibi's avatar
    jennhassibi
    Copper Contributor
    Nov 27, 2017
    My current formula is =IF(lots of formula). It gave me an error.
    • Willy Lau's avatar
      Willy Lau
      Steel Contributor
      Nov 27, 2017
      I think you should find out why there is the error first, and if you do not show us the formula, no one can provide suggestions to you.
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Nov 27, 2017

    jennhassibi,

     

    =ROUNDUP(your_current_formula_without_equal_sign,number_of_decimals)