Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change value of cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change value of cell
Joel,
Where and how do I use/ enter this custom function? Why have you used A8? Thanks for your help Eqa "Joel" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change value of cell
A8 is the cell you want to see the formula. You could put =getformula(A8) in
cell A10 To add the code - go to worksheet and rtight click tab on bottom of sheet (normally sheet1, but can be anythin). Then select View Code (last option). Next from VBA window - Insert Module Copy and paste code posted without the leading . ------------------------------------------------------------------------- Function getformula(cell As Range) getformula = cell.Formula End Function --------------------------------------------------- "Eqa" wrote: Joel, Where and how do I use/ enter this custom function? Why have you used A8? Thanks for your help Eqa "Joel" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change value of cell
Joel,
Thanks for that, but after I have done that all I get in A 10 is the numbers that was inserted into A 8 by solver. So I still don't know what the formula is, or am I doing something wrong? This is an algebra driven formula which I am struggling to work out. Thanks again Eqa "Joel" wrote: A8 is the cell you want to see the formula. You could put =getformula(A8) in cell A10 To add the code - go to worksheet and rtight click tab on bottom of sheet (normally sheet1, but can be anythin). Then select View Code (last option). Next from VBA window - Insert Module Copy and paste code posted without the leading . ------------------------------------------------------------------------- Function getformula(cell As Range) getformula = cell.Formula End Function --------------------------------------------------- "Eqa" wrote: Joel, Where and how do I use/ enter this custom function? Why have you used A8? Thanks for your help Eqa "Joel" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |