ExcelBanter - #Value! error

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - #Value! error (https://www.excelbanter.com/excel-worksheet-functions/107664-re-value-error.html)

Jay

#Value! error

How can I get rid of the dreaded #value! error message if there are blank
cells involved in the calculations?

Max

#Value! error

"Jay" wrote:
How can I get rid of the dreaded #value! error message if there are blank
cells involved in the calculations?

Use an IF construct to front check precedent cells in the formula,
for example something like:
=IF(OR(F32="",$D$34=""),"",$D$34*F32)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

All times are GMT +1. The time now is 04:54 AM.