Forum Discussion

pysnyp's avatar
pysnyp
Copper Contributor
Sep 26, 2020
Solved

Please help

Good morning, I would like to advise with function IF AND or maybe others. For example, we have a table with two columns and one row. (A1;B1) Conditions: if is the value of A1 between "0,01-20,00"...
Formulas and Functions
  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Sep 26, 2020

    pysnyp ,,

     

    You may use this one:

     

    =IF(AND(A1>=0.01,A1<=20),20,IF(A1=0,0,(20+A1-20)*0.7))

     

    N.B. I'm using US keyboard & according to the Regional Settings, DOT is Decimal. 

Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
Sep 26, 2020

pysnyp ,,

 

You may use this one:

 

=IF(AND(A1>=0.01,A1<=20),20,IF(A1=0,0,(20+A1-20)*0.7))

 

N.B. I'm using US keyboard & according to the Regional Settings, DOT is Decimal. 

  • pysnyp's avatar
    pysnyp
    Copper Contributor
    Sep 26, 2020

    Rajesh_Sinha 

    Thanks a lot, it works. Have a nice day.

    Peter

    • Rajesh_Sinha's avatar
      Rajesh_Sinha
      Iron Contributor
      Sep 26, 2020
      Glad to help you,, if you feel then you may mark my post as best response as well like,, keep asking ☺
      • pysnyp's avatar
        pysnyp
        Copper Contributor
        Sep 26, 2020
        You have the best response, thank you, my friend.

Resources