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