View original (French)

Difference between 2 cells with positive or negative result

MysticRevolt Posted messages 3 Status Membre -  
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   -
Hello,

I need to display the difference between cell A and cell B knowing that sometimes A<B, and sometimes A>B. Additionally, the result should show the appropriate symbol, whether it is positive or negative; is that possible?
In A, I have a simple subtraction (for the total hours) and in B the function =ROUND.MROUND(;) (to round this total to the half-hour) but I don't think that's changing anything.
I can't find a formula that calculates the difference without giving an order of calculation, Help please :)

Best regards.

5 réponses

Réponse 1 / 5
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
Hello,

I didn't understand everything, but you just need to perform a simple subtraction A1-B1 for example and format the cell with this custom format

+ # ##0.00;[Red]- # ##0.00

which will give you the positive result preceded by a + and the negative result preceded by a minus, along with the additional red coloring of the negative value
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.
2