if then for a third time

  • Thread starter Thread starter steven
  • Start date Start date
S

steven

i'm trying to see if this can be put in an excel formula:

if P>0
if(S>2/3P and C>1/3P) then pay (2/3P to S and pay 1/3P to
C)
if(S<2/3P and C>P-S) then(pay off S and pay P-S to C)
if(S<2/3P and C<P-S) then (pay off S and pay off C and
distribute P-S-C)

if it's possible what would the formula look like?
 
Hi Steven!

Too many conditions to get into a single formula!

I've got it worked out in several formulas but I don't
understand the last condition:
if(S<2/3P and C<P-S) then (pay off S and pay off C and
distribute P-S-C)
Click to expand...

Does that mean distribute P minus S minus C ?
Distribute to who ?

Biff
 
Something else also:

Your conditions only account for 99% of the value. There
will be "leftovers" that could be pretty substantial
depending on the values used.

Biff
 
Perhaps you need to give us much more information. The way to test your
formulas is with little baby steps.
Try each part by itself and then put it together
if(and(s>2,c>p/3)1,2)
What you are trying to do would have to be in different cells for 2/3 p to S
and 1/3 P to C or use a udf to show a string value.
 
i'm not sure what you mean. how do you get 99%?
-----Original Message-----
Something else also:

Your conditions only account for 99% of the value. There
will be "leftovers" that could be pretty substantial
depending on the values used.

Biff

.
Click to expand...
 
i'm not sure what you mean. how do you get 99%?
if(S<2/3P and C<P-S)
Click to expand...

You only test for 99% of P. Also, depending on the
conditions that you set, a payout from P could total 99%
leaving P with the remaining 1%.

Biff
 
Yeah, I pretty much figured what it was all about.

If I were to try and explain how I did it, I would end up
writing a book. It would be easier if I emailed the
workbook. If you're interested, post a good email address.
Just make sure you munge it in a way that I'll figure it
out. My address is bogus.

Biff
 
thx but i don't know what munge means.
-----Original Message-----
Yeah, I pretty much figured what it was all about.

If I were to try and explain how I did it, I would end up
writing a book. It would be easier if I emailed the
workbook. If you're interested, post a good email address.
Just make sure you munge it in a way that I'll figure it
out. My address is bogus.

Biff

.
Click to expand...
 
He's telling you *not* to post your true e-mail address in plain, readable
text, which can be picked up by the spammers' bots.

Camouflage it in some way that's *obvious* to humans.

My address, for example, I would tell folks to:
Cut out cutout
 
Back
Top