Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checking two different cells
I have to check what is in two different cellszero (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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 cellszero (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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking cells are = and return a value | Excel Discussion (Misc queries) | |||
Checking cells for 2 conditions | Excel Worksheet Functions | |||
Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
Checking Blank Cells | Excel Worksheet Functions | |||
Checking that any cells are null | Excel Worksheet Functions |