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