Create a conditional formula to change the value of other cells

G

Guest

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
 
J

JulieD

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to copy a formula to a 100 cells 3
equaton with #'s Y and N 1
Always Display value in active cell cell x-rows above it ? 1
I have a complex formula where I need to build in a MAX function 4
I am an Idiot Woman 16
How to streamline this Formula? 1
Concatenate problem 7
Need Formula to find worksheet 1

Top