lundi 23 avril 2018

MS Excel - IF then with conditions

I have another tricky Excel IF-Then formula that I need but I can’t figure out how to search for a solution online without knowing the correct terms to use.

What I’m trying to do is generate a result based off of 4 multiple options. This is similar to calculating someone's commission based on what price range they sell an item for.

Result =$1 for an item selling for $0-10.00

Result =$2 for an item selling between $10.01-12.50

Result =$3 for an item selling between $12.51-15.00

Result =$4 for an item selling $15.01 and up

Thanks for any help you can provide.

Aucun commentaire:

Enregistrer un commentaire