Menu
I'd like to write a formula such that if cell A1 displays #VALUE!, say TRUE in cell B1.
Here's my formula in cell B1:
=IF(A1="#VALUE!", "TRUE", "FALSE") I get FALSE when A1 does not say #VALUE! so that part is fine. But, when it does say #VALUE!, I get a #VALUE! error in cell B1, when I want it to say TRUE. How do I do this?
727
To recognize someone, say thank you often, and do so in a specific and individual way. The more specific you are about what you're appreciating or recognizing, the better. It makes the recognition a lot more significant, and the people who were recognized are more likely to sustain that practice in the future.
Use IFERROR(value, value_if_error)
147
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
