Thread: if function or lookup??? across a range of cells in a row.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jwbuyer jwbuyer is offline
external usenet poster
  
Posts: 12
Default if function or lookup??? across a range of cells in a row.
I have data in a row, that I need to find out when any of the cells in that
row equal either 0, or #N/A.

I am having trouble experimenting with both the if function, an lookup.

my worksheet looks like this for example. Any help would be appreciated
A B C
1 0 0
0 1 5
0 0 0
Reply With QuoteReply With Quote