Macro Help

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

Guest

How do I write a macro to tell a cell not to perform the calculation in it if
one of the cells in the calculation is empty? In other words, "Don't do
C5-B5 if C5 is null"
 
You don't need a macro put this formula in the cell instead.

=IF(OR(C5="",B5=""),"",C5-B5)

Mike
 
=if(C5="","",C5-B5)

This is very common if you have a column of formulas, but the column of data
is not complete yet.
 
Back
Top