Hello,
Dear users,
I need your help to create a formula where I can have multiple conditions using IF statement.
See the attached file.
I want a formula like:
Formula:![]()
=IF(E5>=100%;$F$3;IF(AND(E5>=70%;E5<70%);E5*$F$3;"0"))
I don't know where is the error here.
Thank you for your time.
Regards,
Florian
Bookmarks