Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
=E12-(POWER(D12,2)/C12)
=c12-1 =SQRT(b16/c13) I want to write the above formulas into one single formula but I keep getting hung up on subtracting 1 from the cell in c12 How do I get the cell c12 to subtract the value of 1, so that it becomes the new value in the equation but is not changing the actual value in c12? Logically: I have 200 in cell c12 I want to subtract 1 from c12 so that the value for computation becomes 199 and then I sqrt the value in cell b16/c12-1. The value in cell c12 remains 200 it does not change I just need to automate that whatever number is in c12 would be subtracted by 1 during the computation I'm wanting to do this all in one formula Help? Any ideas Thanks - JRH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |