Forum Discussion
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 for...
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:
