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
---------------
Jacob Skaria


"Greg" wrote:

> 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

Thanks that showed me where to insert.

Thanks for your time
Greg