vendredi 28 juillet 2017

"IF" formula in excel using multiple conditions

I need help with an "IF" formula in excel using multiple conditions. This is what i am needing: "IF (cell) is <201, then *$2, if (cell) is 201-400, then *$1.15, if (cell) is >400, then *$1).
I apologize for the "noobness" of question, but i am trying to create a "settlement" spreadsheet.

TIA

Aucun commentaire:

Enregistrer un commentaire