|
Error Checking
Hi, I have a UDF of the form =quality(inputs....). If the conditions are valid, it will return a number between 0 to 1. The way that the UDF works is if the result is less than 0 or greater than 1, it returns #VALUE! which is fine. If this happens, then I would like to be able to assign that cell to be equal to 0. I tried an IF statement but am missing the keyword to recognize the #VALUE!. My IF statement looks like: =IF(quality(inputs....)=*"#VALUE!"*, 0, quality(inputs....)) I can't figure out what to enter in the bold region. I've tried "error", error, #VALUE!, "#VALUE!" along with others. Any help? -- mworth01 ------------------------------------------------------------------------ mworth01's Profile: http://www.excelforum.com/member.php...fo&userid=8991 View this thread: http://www.excelforum.com/showthread...hreadid=543441 |
Error Checking
You might be able to use ISerror(),
=if(iserror(quality(inputs....)),0,quality(inputs. ...)) "mworth01" wrote: Hi, I have a UDF of the form =quality(inputs....). If the conditions are valid, it will return a number between 0 to 1. The way that the UDF works is if the result is less than 0 or greater than 1, it returns #VALUE! which is fine. If this happens, then I would like to be able to assign that cell to be equal to 0. I tried an IF statement but am missing the keyword to recognize the #VALUE!. My IF statement looks like: =IF(quality(inputs....)=*"#VALUE!"*, 0, quality(inputs....)) I can't figure out what to enter in the bold region. I've tried "error", error, #VALUE!, "#VALUE!" along with others. Any help? -- mworth01 ------------------------------------------------------------------------ mworth01's Profile: http://www.excelforum.com/member.php...fo&userid=8991 View this thread: http://www.excelforum.com/showthread...hreadid=543441 |
| All times are GMT +1. The time now is 04:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com