Having trouble

  • Thread starter Thread starter **{Steven}**
  • Start date Start date
S

**{Steven}**

I have a set of numbers, a-e.

A usually equals e but can be less.
B remains constant.
C is the sum of A and B.
C cannot exceed D.
D remains constant

I have tried the following formula in the box for A, but C ends up being
less than D when I want it to equal D

=IF(C>D,E-(C-D))

What am I doing wrong?
 
Uhh, I'm a little slow, but;
If you are putting this formula in A and it's the same "A" that is part
of the "C=Sum A & B" then I think you have a circular reference.
In other words, you're asking xl to resolve "A" by asking "If C> D" but
"C" is equal to "A" + "B" and "A" is the value to be resolved.
("Whew")

I've obviously missed something, maybe you could post the exact
formula's (i.e. row and columns).
 
How do I post just part of it. This is a 3 page spreadsheet and this is the
last equation I need to resolve in order to have a completely functional
setup. Can I attach the file, so you can look at it?

Steven
 
Steven;
I don't think it's necessary to see the workbook (I'll admit that I'm
somewhat hesitant to open anything from an unknown source).
However, if you were to provide a real life example then it would go a
long way in assisting in the solution.

For ex. (where "x" is a row #)
value Bx = <value>
Cx = <value>
Etc Etc.

Formula in Ax - <formula>

What is expected (desired) result given the cell values.
 
Well, between the time I wrote last and reading your reply, my brain started
working again. I have solved the problems. I appreciate your offer of help
though.

Steven
 
Back
Top