Salmana has attended:
Excel Intermediate course
Estimated Cells
We want to be able to indicate that a value in a cell is estimated.
Is it possible to insert a superscript 'E' next to the number in the cell, without it affecting formulas that the cell is used for?
Or are there alternatives to indicate an estimated data-point, without having to colour or change the font of the cell?
RE: Estimated Cells
Hi Salmana,
Thank you for your question.
You could use the concatenation function and try something like this:
=concatenate("e",a3)
This formula will join together the"e" with the cell containing a formula. If the cells change that make up the formula, the concatenated cell updates the formula but retains the letter before it.
I hope this answers your question.
Regards
Simon
RE: Estimated Cells
Hi Salmana,
Just a quick update. The formula I gave you creates the new result in a separate cell.
Go the to the cell with the formula in e.g. = b2*c6 and edit the formula in the formula bar to the following:
=Concatenate("e",b2*c6)
This will update the cell itself.
I hope this helps.
Regards
Simon
