Forum Discussion
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 a...
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))
Try If formula
=IF(SUM((F37/$D$24)*G37*H37*I37)<1.1,1,ROUNDDOWN(SUM((F37/$D$24)*G37*H37*I37),0))
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
