Logical formula

Copper Contributor

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)

2 Replies

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:

Excel 2016 Essential Training (Paid Course)

 

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

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

Thanks.. the beginner in me figured it out on my own