butterfly how to draw The easiest method to deal with the #VALUE error would be to always make positive there aren't any typos in your formulas, and that you’re always using the right data. But this may not always be possible so in this article We are going to help you learn several methods that You should utilize to deal with the #VALUE err