ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sorry, here goes again!!! (https://www.excelbanter.com/excel-worksheet-functions/107665-re-sorry-here-goes-again.html)

Jay

Sorry, here goes again!!!
 
Here's the calculation generating the error, how to get rid of it, if there
are zero or blank cells in the calculations?

=IF(F32="","",$D$34*F32)

Max

Sorry, here goes again!!!
 
"Jay" wrote:
Here's the calculation generating the error, how to get rid of it, if there
are zero or blank cells in the calculations?
=IF(F32="","",$D$34*F32)


Might suffice to check both precedent cells:
=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 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com