Jan 18 2018
06:34 AM
- last edited on
Jul 25 2018
10:48 AM
by
TechCommunityAP
Jan 18 2018
06:34 AM
- last edited on
Jul 25 2018
10:48 AM
by
TechCommunityAP
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)
Jan 18 2018 07:28 AM - edited Jan 18 2018 07:31 AM
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: