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

  • Thread starter Thread starter Dolphinsblue
  • Start date Start date
Sorry trying to find a way to make this work, C1 will be a percentage of the
B1 and D1 left that out.
 
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,""))
 
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%
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My A1,B1,C1&D1 are 1 but why excel2007 return as false? 4
How do I get a total 3
[HELP]CLOCK TIMER USING ECXEL 0
Nested IF Help 3
Format of cell 1
Different cells that need to sum in one 4
Format of cell 1
Formula for If "" AND "" are true... 3

Back
Top