oblix
Board Regular
- Joined
- Mar 29, 2017
- Messages
- 183
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
Hi There all
I have this formula:
=IF(ISERROR(MATCH(A20;'SL1'!$B$7:$B$489;0));"";INDEX('SL1'!$K$7:$K$489;MATCH(A20;'SL1'!$B$7:$B$489;0)))
I am Having a terrible time to try and add roundup to this formula
Please can someone assist
Thank you
I have this formula:
=IF(ISERROR(MATCH(A20;'SL1'!$B$7:$B$489;0));"";INDEX('SL1'!$K$7:$K$489;MATCH(A20;'SL1'!$B$7:$B$489;0)))
I am Having a terrible time to try and add roundup to this formula
Please can someone assist
Thank you