| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a formula for if cells a1 and a2 are the same then cell a3
How do I make cell A3 equal 4 if cells A1 and A2 are the same?
For example if cell A1 and A2 have a X in it, then cell A3 =4 or if cell A1 and A2 are blank then cell A3 =4 As long as the cells match, cell A3=4 If cells do not match then cell A3 =0 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a formula for if cells a1 and a2 are the same then cell a3
=IF(A1=A2,4,0)
or =(A1=A2)*4 -- David Biddulph delete automatically wrote: How do I make cell A3 equal 4 if cells A1 and A2 are the same? For example if cell A1 and A2 have a X in it, then cell A3 =4 or if cell A1 and A2 are blank then cell A3 =4 As long as the cells match, cell A3=4 If cells do not match then cell A3 =0 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a formula for if cells a1 and a2 are the same then cell a3
=if(A1=A2,4,0)
Hope this helps. "delete automatically" wrote: How do I make cell A3 equal 4 if cells A1 and A2 are the same? For example if cell A1 and A2 have a X in it, then cell A3 =4 or if cell A1 and A2 are blank then cell A3 =4 As long as the cells match, cell A3=4 If cells do not match then cell A3 =0 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a formula for if cells a1 and a2 are the same then cel
Yes, that worked. But what would i have to do to make cell A4 be 4 if cell
A1, A2 A3 are the same and have cell A4 be 0 if A1 A2 A3 do notr match in any order? "David Biddulph" wrote: =IF(A1=A2,4,0) or =(A1=A2)*4 -- David Biddulph delete automatically wrote: How do I make cell A3 equal 4 if cells A1 and A2 are the same? For example if cell A1 and A2 have a X in it, then cell A3 =4 or if cell A1 and A2 are blank then cell A3 =4 As long as the cells match, cell A3=4 If cells do not match then cell A3 =0 . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a formula for if cells a1 and a2 are the same then cel
If you want to know how the Excel AND function works, look it up In Excel
help. [The same applies for every other Excel function except DATEDIF.] -- David Biddulph "deepokerman" wrote in message ... Yes, that worked. But what would i have to do to make cell A4 be 4 if cell A1, A2 A3 are the same and have cell A4 be 0 if A1 A2 A3 do notr match in any order? "David Biddulph" wrote: =IF(A1=A2,4,0) or =(A1=A2)*4 -- David Biddulph delete automatically wrote: How do I make cell A3 equal 4 if cells A1 and A2 are the same? For example if cell A1 and A2 have a X in it, then cell A3 =4 or if cell A1 and A2 are blank then cell A3 =4 As long as the cells match, cell A3=4 If cells do not match then cell A3 =0 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell value based on another cells formula??? | Excel Discussion (Misc queries) | |||
| How can i hide cells using formula if the cell has no value? | Excel Discussion (Misc queries) | |||
| comparing 2 cells where 1 is a cell with a formula | Excel Discussion (Misc queries) | |||
| formula for multiply one cell to one of two other cells? | Excel Discussion (Misc queries) | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
Linear Mode
