Home>

Thanks for your attention.

Excuse me for beginner questions.

The function as the subject
L49 = IF (OR (SUM (Y14: AC44) ="", SUM (Y14: AC44) = 0),"", SUM (Y14: AC44))
I made it
Cannot display normally ...

Are you sure I want to ask what is wrong?
I need your help other than a severe response that I am smart.

  • Answer # 1

    When I checked it at hand, it worked for 1 trillion (1,000,000,000,000) for the time being.
    If you increase the width of the cell, I feel like it will be displayed without any problems.

  • Answer # 2

    With SUM range
    = IF (J30>TIME (22,0,0), J30-TIME (22,0,0),"")
    Because there was
    = MAX (0, J43-TIME (22,0,0))
    Then solved it.
    ""may have a value ...

    I'm sorry for the nasty question.

  • Answer # 3

    Hmm If it is negative or too large

    ##### is displayed, so try to narrow the range ...