Sep 26 2020 01:37 AM
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" = B1 must be "20,00"
if is the value of A1 "0" = B1 must be "0" (zero)
if is the value of A1 "20,01-and more = B1 It shall be calculated as follows (20+((A1-20)*0,7))
Could you help me, someone?
Thank you.
Peter
Sep 26 2020 01:49 AM
Solution@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.
Sep 26 2020 05:32 AM
Sep 26 2020 05:35 AM
Sep 27 2020 03:00 AM
Sep 27 2020 09:44 AM
Still didn't catch. Initial requirement
if is the value of A1 "20,01-and more = B1 It shall be calculated as follows (20+((A1-20)*0,7))
21 is more than 20.01, thus formula shall return (20+((21-20)*0,7))=(20+((1)*0,7))=(20+1*0,7)=20,7
Why did you decide the formula shall calculate A1*0.7 ?
Sep 27 2020 11:53 PM
Sep 26 2020 01:49 AM
Solution@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.