=IF(AF14=1,AF8-AM10-AM11-AM15*2+0.0787,IF(AF14=2,AF8-AM10-AM11-AM15*4/2-0.125+0.1575,"0"))
How do I add MROUND to this?
=IF(AF14=1,AF8-AM10-AM11-AM15*2+0.0787,IF(AF14=2,AF8-AM10-AM11-AM15*4/2-0.125+0.1575,"0"))
How do I add MROUND to this?
=MROUND(IF(AF14=1,AF8-AM10-AM11-AM15*2+0.0787,IF(AF14=2,AF8-AM10-AM11-AM15*4/2-0.125+0.1575,0)),"the multiple you want to round to")
Difficult to know for sure without a sample workbook.
Please click the * icon below if I have helped.
Thanks, works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks