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

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

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

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