M
mworth01
Hi,
I have a UDF of the form =quality(inputs....). If the conditions ar
valid, it will return a number between 0 to 1. The way that the UD
works is if the result is less than 0 or greater than 1, it return
#VALUE! which is fine. If this happens, then I would like to be abl
to assign that cell to be equal to 0. I tried an IF statement but a
missing the keyword to recognize the #VALUE!. My IF statement look
like:
=IF(quality(inputs....)=*"#VALUE!"*, 0, quality(inputs....))
I can't figure out what to enter in the bold region. I've trie
"error", error, #VALUE!, "#VALUE!" along with others. Any help
I have a UDF of the form =quality(inputs....). If the conditions ar
valid, it will return a number between 0 to 1. The way that the UD
works is if the result is less than 0 or greater than 1, it return
#VALUE! which is fine. If this happens, then I would like to be abl
to assign that cell to be equal to 0. I tried an IF statement but a
missing the keyword to recognize the #VALUE!. My IF statement look
like:
=IF(quality(inputs....)=*"#VALUE!"*, 0, quality(inputs....))
I can't figure out what to enter in the bold region. I've trie
"error", error, #VALUE!, "#VALUE!" along with others. Any help