Thread
:
formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
Posts: n/a
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
Reply With Quote