View original (French)

Do not display a negative value in Excel

Solved
Luckies -  
 Utilisateur -
Good evening,

I'm looking to see if it's possible for a calculation to display a dash if it equals or is less than 0, and to display the result of the calculation if the cell's result is equal to or greater than 0.

I've been searching for quite some time and I can't find anything.

Thank you in advance for your responses.

Luckies
Configuration: Windows 2003 Internet Explorer 8.0

8 answers

  1.
    g Posted messages 1285 Status Member 578
     
    Hello,

    =IF(calculation<=0;"-";calculation)

    Good evening?
    19
    1. Utilisateur
       
      Thank you for the formula.
      0
  2. Luckies
     
    Good evening,

    Actually, it doesn't work, it gives me the value #name?

    Sincerely

    Luckies
    2
  3. Luckies
     
    Well, excuse me

    I just understood my mistake and it works perfectly fine now

    Thank you for your response

    Luckies
    2
  6. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello Alex,

    there's a faster way 
    = IF(cell <=0, cell)


    Best regards.
    --
    If we were to lock all the idiots in closets,
    there would be no one left to close the doors.
    2
  7. Luckies
     
    Good evening,

    Thank you very much!

    Sincerely

    Luckies
    1
  8. g Posted messages 1285 Status Member 578
     
    Re,

    Share your formula, it will be easier.

    See you later.
    1
  9. falou
     
    Thank you, it’s exactly what I was looking for ;)
    1