D
Dolphinsblue
any ideas to help make this work
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
Will C1 ever be a negative number?
What should happen if B=D?
What should happen if B=D?
D
Dolphinsblue
Sorry trying to find a way to make this work, C1 will be a percentage of the
B1 and D1 left that out.
B1 and D1 left that out.
T
T. Valko
Try this...
You still didn't say what should happen if B=D so in that case the formula
will return a blank.
=IF(B1>D1,-C1,IF(D1>B1,C1,""))
You still didn't say what should happen if B=D so in that case the formula
will return a blank.
=IF(B1>D1,-C1,IF(D1>B1,C1,""))
D
Dolphinsblue
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%
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%
R
RA
How about this?
=IF(B1>D1,((B1-D1)/D1)+1,(((B1-D1)/D1)+1)*-1)
=IF(B1>D1,((B1-D1)/D1)+1,(((B1-D1)/D1)+1)*-1)
R
RA
Soory, got it backwards:
=IF(B1<D1,(((B1-D1)/D1)+1)*-1,((B1-D1)/D1)+1)
=IF(B1<D1,(((B1-D1)/D1)+1)*-1,((B1-D1)/D1)+1)
T
T. Valko
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.
Try this:
=IF(D1=0,"",IF(B1<D1,-ROUND(B1/D1,3),ROUND(B1/D1,3)))
Format as Percentage to 1 decimal place.