=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

any ideas to help make this work

=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

Will C1 ever be a negative number?

What should happen if B=D?

--
Biff
Microsoft Excel MVP


"Dolphinsblue" wrote in message
...
any ideas to help make this work

=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

Sorry trying to find a way to make this work, C1 will be a percentage of the
B1 and D1 left that out.

"Dolphinsblue" wrote:

any ideas to help make this work

=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

Try this...

You still didn't say what should happen if B=D so in that case the formula
will return a blank.

=IF(B1D1,-C1,IF(D1B1,C1,""))

--
Biff
Microsoft Excel MVP


"Dolphinsblue" wrote in message
...
Sorry trying to find a way to make this work, C1 will be a percentage of
the
B1 and D1 left that out.

"Dolphinsblue" wrote:

any ideas to help make this work

=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

Ok Sorry, For example I need this to happen


If B1 has 40 in it and D1 has 60 in it then C1 should be -66.6%

but

If B1 has 60 in it and D1 has 40 in it then C1 should be 150%

and if B1 and D1 are equal C1 is 100%



"T. Valko" wrote:

Try this...

You still didn't say what should happen if B=D so in that case the formula
will return a blank.

=IF(B1D1,-C1,IF(D1B1,C1,""))

--
Biff
Microsoft Excel MVP


"Dolphinsblue" wrote in message
...
Sorry trying to find a way to make this work, C1 will be a percentage of
the
B1 and D1 left that out.

"Dolphinsblue" wrote:

any ideas to help make this work

=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

How about this?

=IF(B1D1,((B1-D1)/D1)+1,(((B1-D1)/D1)+1)*-1)

=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

Soory, got it backwards:

=IF(B1<D1,(((B1-D1)/D1)+1)*-1,((B1-D1)/D1)+1)

"RA" wrote:

How about this?

=IF(B1D1,((B1-D1)/D1)+1,(((B1-D1)/D1)+1)*-1)

=IF(AND(B1D1)=C1*-1,IF(AND(D1B1)=C1*1))
 

Ok, I think we finally understand!

Try this:

=IF(D1=0,"",IF(B1<D1,-ROUND(B1/D1,3),ROUND(B1/D1,3)))

Format as Percentage to 1 decimal place.

--
Biff
Microsoft Excel MVP


"Dolphinsblue" wrote in message
...
Ok Sorry, For example I need this to happen


If B1 has 40 in it and D1 has 60 in it then C1 should be -66.6%

but

If B1 has 60 in it and D1 has 40 in it then C1 should be 150%

and if B1 and D1 are equal C1 is 100%



"T. Valko" wrote:

Try this...

You still didn't say what should happen if B=D so in that case the
formula
will return a blank.

=IF(B1D1,-C1,IF(D1B1,C1,""))

--
Biff
Microsoft Excel MVP


"Dolphinsblue" wrote in message
...
Sorry trying to find a way to make this work, C1 will be a percentage
of
the
B1 and D1 left that out.

"Dolphinsblue" wrote:

any ideas to help make this work