View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefan - AW Stefan - AW is offline
external usenet poster
 
Posts: 1
Default checking two different cells

I have to check what is in two different cells€¦zero (or nothing €œ€) or number
(result of a formula in each cell) and according with the answer, if number I
run a new formula using these two numbers.
If not, I check for two other cells (beside), and repeat the whole
procedure. And so on €¦
The difficulty is that the columns have different data. Sometime zero (or
nothing €œ€), sometime number.
How can I compare them?
Ex:
A1=0 B1=12 D1=11 E1=0
A2=34 B2=56 D2=0 E2=0
A3=78 B3=0 D3=0 E3=22
A4=0 B4=0 D4=0 E4=0