| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two formulas in one cell
Sometimes I cannot respond whether an answer was helpful or not, but I am
desperate for help with the following: D8 shows €œH€ and D9 shows €œ8€ E8 shows €œMO€ and E9 shows €œ8€ How can I have column V8 show €œ8€, €œ8€? ALSO D8 shows €œS€ and D9 shows €œ8€ E8 shows €œSF€ and E9 shows €œ8€ How can I have column R8 show €œ8€ and column U8 show €œ8€? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two formulas in one cell
Hi,
I assumed you meant if cell doesn't match you want blank space =if(and(D8="H",D9=8),8,"") =if(and(E8="MO",E9=8,8,"") change cells to fit your needs in the other cases hopes this helps "something68" wrote: Sometimes I cannot respond whether an answer was helpful or not, but I am desperate for help with the following: D8 shows €œH€ and D9 shows €œ8€ E8 shows €œMO€ and E9 shows €œ8€ How can I have column V8 show €œ8€, €œ8€? ALSO D8 shows €œS€ and D9 shows €œ8€ E8 shows €œSF€ and E9 shows €œ8€ How can I have column R8 show €œ8€ and column U8 show €œ8€? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two formulas in one cell
Hi,
I was thinking that maybe what you need is a combination =IF(AND($d$9=8,$e$9=8),IF(AND($D$8="H",$E$8="MO"), "8","")) "Eduardo" wrote: Hi, I assumed you meant if cell doesn't match you want blank space =if(and(D8="H",D9=8),8,"") =if(and(E8="MO",E9=8,8,"") change cells to fit your needs in the other cases hopes this helps "something68" wrote: Sometimes I cannot respond whether an answer was helpful or not, but I am desperate for help with the following: D8 shows €œH€ and D9 shows €œ8€ E8 shows €œMO€ and E9 shows €œ8€ How can I have column V8 show €œ8€, €œ8€? ALSO D8 shows €œS€ and D9 shows €œ8€ E8 shows €œSF€ and E9 shows €œ8€ How can I have column R8 show €œ8€ and column U8 show €œ8€? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
| CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
| How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
| Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
| change cell value greater than another cell value using formulas | Excel Worksheet Functions | |||
Linear Mode
