Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking cells are = and return a value
Hi dose any one know how to ckeck if two or more cells are true and then
return a value e.g if one cell = 10 and another cell =20 then return a value of another cell or what ever it needs to be |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking cells are = and return a value
Say your two cells are A1 and A2. And you want to bring back the value of A3 if
A1=10 and A2=20. But you want to bring back a value from A4 if at least one of them is different (a1 different from 10 or a2 different from 20): =if(and(a1=10,a2=20),a3,a4) You could even show text: =if(and(a1=10,a2=20),a3,"A1 and A2 are not what they should be!") You may want to provide more details if this doesn't help. nev1956 wrote: Hi dose any one know how to ckeck if two or more cells are true and then return a value e.g if one cell = 10 and another cell =20 then return a value of another cell or what ever it needs to be -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell Checking with checking cell notes | 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 |