add Rounding function to this formula
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 |
add Rounding function to this formula
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 |
add Rounding function to this formula
Thanks that showed me where to insert.
Thanks for your time Greg |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com