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.

Score	PP deduction
90.0%	15.5
90.0%	0.02
95.9%	0.02
96.0%	0.01
99.4%	0.01

<colgroup><col><col></colgroup><tbody>
</tbody>

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.