View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DonkeyOte[_3_] DonkeyOte[_3_] is offline
external usenet poster
 
Posts: 2
Default checking two different cells

might be an idea to outline your expected / desired results - it's quite
difficult to comprehend presently.

"Stefan - AW" wrote:

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