Create a conditional formula to change the value of other cells
 

I have a Loan-To-Value formula referring to cell c13(the property value),
c14(the loan amount), and c17(the Loan-to-Value). The formula in c17 of
course is
=c14/c13. This works obviously.

How do I assign values to other cells from a subject cell? can a formula
attached to cell 'e15' for example be conditioned to change the results or
the values in cells 'c14' or 'c17' conditionally?

If c17 is known and c14 is not, I would like to select an option from my
list that assigns a calculated value to c14 by multiplying c17 and c13.

I would also like if c17 is not known but c14 is, to divide(c14/c13) to
yield a result in c17.

Your help is appreciated

Hi

a formula can only act on the cell it is in ... to do anything else you
need to use VBA code ... is this a possible option for you?
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Orca" wrote in message
...
I have a Loan-To-Value formula referring to cell c13(the property value),
c14(the loan amount), and c17(the Loan-to-Value). The formula in c17 of
course is
=c14/c13. This works obviously.

How do I assign values to other cells from a subject cell? can a formula
attached to cell 'e15' for example be conditioned to change the results or
the values in cells 'c14' or 'c17' conditionally?

If c17 is known and c14 is not, I would like to select an option from my
list that assigns a calculated value to c14 by multiplying c17 and c13.

I would also like if c17 is not known but c14 is, to divide(c14/c13) to
yield a result in c17.

Your help is appreciated