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"...
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 ,,
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 ☺
- You have the best response, thank you, my friend.
- Glad to help you, keep asking ☺