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 Tesolin!
You could try this formula:
=MAX(1,INT(F37*G37*H37*I37/$D$24))
or
=MAX(1,INT(PRODUCT(F37:I37)/$D$24))
Blessings!