Forum Discussion
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" = 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
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.
11 Replies
- Your formula needs little correction in case of value is other than 20 gives wrong result,, please check this part (A16-20)*0.7).
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.
- Glad to help you,, if you feel then you may mark my post as best response as well like,, keep asking ☺
