View original (French)

Difference between 2 cells with positive or negative result

MysticRevolt Posted messages 3 Status Member -  
Mike-31 Posted messages 18405 Registration date   Status Contributor 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 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    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