| 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 |
| 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 | |||
Threaded Mode
