Thread
:
How do get the LOOKUP function to not read empty cells as zeros
View Single Post
#
9
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_]
external usenet poster
Posts: 1,231
How do get the LOOKUP function to not read empty cells as zeros
Teethless mama wrote...
....and another
=1-A1
....
Expand for blank cells to
=IF(COUNT(A1),1-A1,"")
Reply With Quote
Harlan Grove[_2_]
View Public Profile
Find all posts by Harlan Grove[_2_]
How do get the LOOKUP function to not read empty cells as zeros