View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dena Dena is offline
external usenet poster
 
Posts: 12
Default Returning a zero

I have a worksheet with 2 sheets. The first sheet has all formulas and
depends on the second sheet. I need a formula in sheet 1 that subtracts cell
a1 from cell b1 but if cell a1 is zero I want the formula to return a zero.
Is this possible?