add Rounding function to this formula

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I'm not sure where to insert the round function to this formulas result.
i have tried a couple different things with no resolve.
it needs to be normal rounding .4 down .5 up
=IF(B10="M",IF($C$2-C10<0,0,($C$2-C10)*$B$2),IF($C$3-C10<0,0,($C$3-C10)*$B$3))

Many Thanks in advance.
Greg
 
Try....rounded to 2 decimals
=IF(B10="M",ROUND(MAX(0,($C$2-C10)*$B$2),2),
ROUND(MAX(0,($C$3-C10)*$B$3),2))

If this post helps click Yes
 
Back
Top