Forum Discussion

Sonia Tesolin's avatar
Sonia Tesolin
Copper Contributor
May 22, 2018

Excel Formula

Hi


I have a current formula that has a ROUNDDOWN based on a SUM 

 

=ROUNDDOWN(SUM((F37/$D$24)*G37*H37*I37),0)

 

What I wanted to know is if it was possible to combine round formula's (or add an IF?) to this.

Basically we want to keep the round down if the result of the SUM is 1.1 and higher but if the result of the SUM is < 0.9 then we want to have this round up the result to 1.  

 

I've tried lots of forums and excel help sites but I couldn't find anything so hoping a forum guru might be able to assist.

 

Thank you! Sonia

Formulas & Functions
Need Help

2 Replies

  • Tomasz Kocur's avatar
    Tomasz Kocur
    Brass Contributor
    May 23, 2018
    Hi Sonia

    Try If formula

    =IF(SUM((F37/$D$24)*G37*H37*I37)<1.1,1,ROUNDDOWN(SUM((F37/$D$24)*G37*H37*I37),0))
    • Sonia Tesolin's avatar
      Sonia Tesolin
      Copper Contributor
      Jun 05, 2018

      Thank you for taking the time to reply Tomasz...the below didn't quite give me what I was after but I am still really appreciative of your time! Take care, Sonia

Resources