Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i have more than one formula in the same cell?
i would like to have 2 different formulas in the same cell, is it possibel?
And apply conditional formating to anothercell (different than the one were our base value is taken in account)? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i have more than one formula in the same cell?
No .... what exactly do you want to do?
"ana" wrote: i would like to have 2 different formulas in the same cell, is it possibel? And apply conditional formating to anothercell (different than the one were our base value is taken in account)? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i have more than one formula in the same cell?
Only one per customer............but you can use and IF formula in the cell
to maybe get the effect of two formulas..........it depends on what you're trying to do.....a little more explanation would be helpful. Vaya con Dios, Chuck, CABGx3 "ana" wrote: i would like to have 2 different formulas in the same cell, is it possibel? And apply conditional formating to anothercell (different than the one were our base value is taken in account)? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i have more than one formula in the same cell?
Yes but you need to be more explicit in telling what you want
You can use an ampersand like this =IF(A1A2,2,3)&" "&IF(B1B2,3,4) and yes you can use conditional formatting in a cell based on another cell -- Regards, Peo Sjoblom "ana" wrote in message ... i would like to have 2 different formulas in the same cell, is it possibel? And apply conditional formating to anothercell (different than the one were our base value is taken in account)? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"the formula in this cell differs from the formula in this area o. | Excel Worksheet Functions | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |