Checking each cell for a value prior to calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to check each cell for a valid non "" value during a calculation. If one or both of the cells happens to be blank "", then plug in a 0 as a resulting value. Example: AD12 - X12. I've tried the ISNUMBER function and a couple of IF functions, none have given me the result I need

Thanks
 
=IF(OR(AD12="",X12=""),0,AD12-X12)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Danny said:
I would like to check each cell for a valid non "" value during a
Click to expand...
calculation. If one or both of the cells happens to be blank "", then plug
in a 0 as a resulting value. Example: AD12 - X12. I've tried the ISNUMBER
function and a couple of IF functions, none have given me the result I need.
 
Back
Top