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
|