• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to calculate this?if85%=5, 95%=2, 80%=?

Hi,

Welcome to the forum :)...

That would be a simple nested IF formula.
If you intend to have more options, like 70%, 65%, 50%, and so on, it will be better to use a helper table and do a VLOOKUP to return the values.

Please refer to attachment.
 

Attachments

  • IF.xlsx
    9.2 KB · Views: 6
Back
Top