Change value of cell
You can create a custom function. Use the one below
call with function below on worksheet
=getformula(A8)
Function getformula(cell As Range)
getformula = cell.Formula
End Function
"Eqa" wrote:
I have a a value in a cell that solver worked out for me. It is an algebra
formula. Is there some way of seeing the actual formula? This formula
established the % that I need to take of Col A the cost price to get to Col B
the selling price at a pre determined GP of 27%. IE what I am trying to say
that the % required to go from cost to w/sale is 37.5% but I would like to
see the GP figure of 27% on the spreadsheet so what formula do I need to
enter.
I hope this all make sense and someone could help me.
Thanks Eqa
|