If you do a lot of calculations with denominators of 0 or Vlookups where there is not a match, then you probably have spreadsheets with Error messages. Tired of printing or publishing spreadsheets that display errors? Use Excel 2007's new function to hide those error messages. DIV/!0 and N/A# be gone!
=if(a1=0,0,if(b2=0,0,a1/b2 (Good for excel 2003), once you have typed this enough you get pretty quick at it
qual4528 6 months ago
=if(a1=0,0,if(b2=0,0,a1/b1 (Good for excel 2003)
qual4528 6 months ago
TYVM for this vid :D
Metman19 2 years ago