View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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