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