Bullets

[husainmusani]

how to apply formulas in bullets?
i want three bullets in a single cell each having different formula, in the single cell

 

[gruntingmonkey]

The calculation cant be done in one cell. You can however have the calculation done in three cells and then use the concatenate function to be able to show the data in one cell - without bullets.

Example:
If your three separate calculations are in A1, A2 & A3

In cell A4 put the following code and wrap the text.
=CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3)

 

[footoo]

Or with bullets :
=CONCATENATE(CHAR(149),A1,CHAR(10),CHAR(149),A2,CHAR(10),CHAR(149),A3)