View original (French)

IF formula --> greater than but less than...

Solved
samisami -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I am trying to create an Excel formula for the following explanation using the IF formula. But I'm having trouble.

Can you help me?

If the amount in C1 is greater than or equal to 100 it should return C1 * 0.5

If the amount is less than 100 in C1, it should return 0

BUT ALSO, if the amount is equal to or greater than 1400, it should return 700

Thank you in advance,
Sami

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    check with

    =MIN(IF(C1>=100,C1*0.5,0),700)

    best regards
    --
    The quality of the answer mainly depends on the clarity of the question, thank you!
    2
    1. samisami
       
      Thank you!!! It's working!
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      No problem
      Safe travels
      I'm marking the topic as resolved
      Regards
      0