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. 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 26, 2020

pysnyp 

As variant

=MAX(20,20+(A1-20)*0.7)*(A1>0)

Resources