Forum Discussion

Kimberly Farrell's avatar
Kimberly Farrell
Copper Contributor
Jan 18, 2018

Logical formula

Me again .. (almost think I'm new to excel ! )

Here's what I want to do:

if K7 is less than 3 enter 112.5, if K7 is between 3-9 enter 150, if K7 is greater than 10 enter 187.50


here's the formula I have but I've got something wrong ..

=IF(K7,">3",112.5)*OR(K7,"3:9",150)*OR(K7,"<10",187.5)

Formulas & Functions
Need Help

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jan 18, 2018

    Kimberly,

     

    This is for you:

    =IF(K7<3,112.5,IF(AND(K7>=3,K7<=9),150,IF(K7>10,187.5,"")))

     

    If you want the last condition to be greater than or equal 10, take this:

    =IF(K7<3,112.5,IF(AND(K7>=3,K7<=9),150,IF(K7>=10,187.5,"")))

    If you're absolutely beginner, I recommend you to take some essential courses such as:

    https://www.lynda.com/Excel-tutorials/Excel-2016-Essential-Training/376985-2.html?srchtrk=index%3a2%0alinktypeid%3a2%0aq%3aExcel+2016+essiential+training%0apage%3a1%0as%3arelevance%0asa%3atrue%0aproducttypeid%3a2 (Paid Course)

     

    You can find too many free resources on the Internet such as:

    http://www.excel-easy.com/

Resources