Liz has attended:
SharePoint course
Excel
WE have a column with the formula =IF(B7-F7>0,B7-E7&" units to add",B7-E7& "units to remove")
Some of the numerical contents have umpteen decimal places, others don't. How can we reduce integers (i.e. round down to unit, no decimal places)
Many thanks
RE: excel
Hi Liz,
Thank you for the forum question.
Try:
=IF(B7-F7>0,Int(B7-E7)&" units to add",Int(B7-E7)& "units to remove")
You can also instead of the Int function use the Rounddown function.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
