janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 117
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I am trying to write this formula that is doing a simple division calculation, but asking it to round the answer to two decimal points and return a blank if it is an error (i.e. no data from one source).
=ROUND(IFERROR(K366/S366,""),2)
=IFERROR(ROUND(K366/S366,2),"")
Both of the above formulas still return a "#VALUE!" error. They do round to 2 decimal points, but don't blank out the errors. Help please.
Thank you in advance for your expertise and knowledge friends!
=ROUND(IFERROR(K366/S366,""),2)
=IFERROR(ROUND(K366/S366,2),"")
Both of the above formulas still return a "#VALUE!" error. They do round to 2 decimal points, but don't blank out the errors. Help please.
Thank you in advance for your expertise and knowledge friends!