IF statement

Resolved · Medium Priority · Version 2016

Thu 10 Dec 2020, 18:16 Delegate 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:41 Trainer 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:59 Delegate 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:03 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

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