View Single Post
  #1   Report Post  
JRH
 
Posts: n/a
Default computation problems -- formulas

=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