Can this work

Closed
Dolphinsblue - Jun 23, 2009 at 12:28 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 23, 2009 at 04:41 AM
Hello,
I need a little help on making this work.

=IF(AND(B1>D1)=C1*-1,IF(AND(D1>B1)=C1*1))

I need c1 to be a percentage of B1 and D1 of the difference between the two.

1 reply

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 161
Jun 23, 2009 at 04:41 AM
Really unable to under stand what you want ?????? be more specific what you actually want and tell me in details what result you want ....... i though you want below result ..... Try this formula in C1

=IF(B1>D1,-1,1)

0