Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default formula

Try this:

=IF(OR(I21="",H21=""),0,I21-H21+1)

If either I21 or H21 (or both) are blank, then return a zero, otherwise
your formula.

Hope this helps.

Pete