can i have more than one formula in the same cell?

A

ana

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
 
C

CLR

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
 
P

Peo Sjoblom

Yes but you need to be more explicit in telling what you want

You can use an ampersand like this

=IF(A1>A2,2,3)&" "&IF(B1>B2,3,4)


and yes you can use conditional formatting in a cell based on another cell
 
Top