Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting formula | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Formula results in font color change | Excel Worksheet Functions |