if statement

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

# IF statement

Resolved · Medium Priority · Version 2016

Kay has attended:
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

### 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

### 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.

### 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 courses

Training information:

 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 What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Activating the formula bar with the keyboard in Excel 2010

The 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.

View all Excel hints and tips