Question
How do I handle a divisor that might be a text string?
Asked by: USER9415
54 Viewed
54 Answers
Answer (54)
If your divisor cell might contain text, you need to first convert it to a number using the `VALUE()` function. However, be aware that `VALUE()` will return an error if the text cannot be converted to a number. Use `IFERROR` in conjunction with `VALUE()` to handle this scenario. For example, `=IFERROR(VALUE(B1)/A1, 0)`.