98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF statement
IF statement
Resolved · Medium Priority · Version 2016
Thu 10 Dec 2020, 18:16Delegate Kay said...
Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
IF statement
Hi
Please can you help to point me in the correct direction for the following IF statement
I am looking to combine 2 IF statements for the following and need some assistance as to how best to build this.
Example:
Column A = 2
Column B = 70
if(column A > or = 3) and /or (column B > or = 70 then return 100
if (Column A < 3) and/or (Column B < 70) then return 20
Many Thanks
Fri 11 Dec 2020, 10:41Trainer Marius said...
RE: IF statement
Hello Kay,
Thank you for your question. Below are some examples of how you could write the formulas:
=IF(AND(A2>=3,B2>=70),100,IF(AND(A2<3,B2<70),20))
* This formula requires all tests to be TRUE.
=IF(OR(A2>=3,B2>=70),100,IF(OR(A2<3,B2<70),20))
* This formula requires either Column A or Column B tests to be TRUE.
I hope this helps.
Kind regards
Marius Barnard
STL
Wed 16 Dec 2020, 16:59Delegate Kay said...
RE: IF statement
Hi Marius,
Thankyou so much for your prompt reply. This is exactly what I needed.
Wishing you and family a happy Christmas and A Safe and Healthy New Year
Thanks once again.
Wed 16 Dec 2020, 18:03Trainer Marius said...
RE: IF statement
Hi Kay,
Glad I could be of help. I wish you and your family a merry Christmas too!
Kind regards
Marius
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Activating the formula bar with the keyboard in Excel 2010The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell. |
