IF statement Help

[andycreber]

Hi,
Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible.

scenario:


Total number of items = 39

For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and

For each item that is failed, 0.02 point deducted per 0.02% that the item is below 96% but above or equal to 90% and

For each item that is failed, 15.5 point deducted that the item is below 90%

​

Happy to have a table using each score and point deduction similar to below if easier for combining Vlookup and likewise using more cells of table data to get the result.
[TABLE="width: 246"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Score[/TD]
[TD]PP deduction[/TD]
[/TR]
[TR]
[TD="align: right"]90.0%[/TD]
[TD="align: right"]15.5[/TD]
[/TR]
[TR]
[TD="align: right"]90.0%[/TD]
[TD="align: right"]0.02[/TD]
[/TR]
[TR]
[TD="align: right"]95.9%[/TD]
[TD="align: right"]0.02[/TD]
[/TR]
[TR]
[TD="align: right"]96.0%[/TD]
[TD="align: right"]0.01[/TD]
[/TR]
[TR]
[TD="align: right"]99.4%[/TD]
[TD="align: right"]0.01[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance, please let me know if you need further clarification.

 

[Robby19]

Duplicate post. See: https://www.mrexcel.com/forum/excel-questions/1060040-if-statement-help.html

Asked and answered per OP's requirements.