# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello, I need help. (Excel) Assume that columns A, C and E in a worksheet contain the names of three adults who are interested in joining the (AARP), 50 years of age and over improve the quality of their lives. Columns B, D and F contain their respective ages in whole years in the adjacent cells. Which of the following formulas should be placed in cell G1 to verify that anyof these individuals are eligible to become full members, if they are at least 50 years old? =AND(B1>49, D1>49, F1>49) =OR(B1>=50, AND(D1>=50, F1>=50)) =OR(B1>=50, D1>=50, F1>=50) =AND(B1>=50, D1>=50, F1>=50
Solved by F. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/04/2018 - 03:47
Hi
User 29/04/2018 - 03:47
hi
Excelchat Expert 29/04/2018 - 03:47
Welcome to Got it Pro
Excelchat Expert 29/04/2018 - 03:48
Excelchat Expert 29/04/2018 - 03:48
Hello
User 29/04/2018 - 03:48
one sec
Excelchat Expert 29/04/2018 - 03:49
Yes please put the data so that i can work on formulas
User 29/04/2018 - 03:50
Excelchat Expert 29/04/2018 - 03:50
ok
Excelchat Expert 29/04/2018 - 03:51
Waiting
User 29/04/2018 - 03:51
duh, you dont think i know this
User 29/04/2018 - 03:52
its not something I can just copy and paste, give me a minute
Excelchat Expert 29/04/2018 - 03:52
ok
Excelchat Expert 29/04/2018 - 03:56
I am waiting
Excelchat Expert 29/04/2018 - 03:56
You can just write on spreadsheet and show
Excelchat Expert 29/04/2018 - 03:56
what exactly you require
Excelchat Expert 29/04/2018 - 04:03
Hey
Excelchat Expert 29/04/2018 - 04:03
I have showed what all these means
Excelchat Expert 29/04/2018 - 04:03
Hope this helps
Excelchat Expert 29/04/2018 - 04:05
Basis the description you can choose to decide which one to use
Excelchat Expert 29/04/2018 - 04:05
Excelchat Expert 29/04/2018 - 04:05
It really helps
Excelchat Expert 29/04/2018 - 04:05
Have a great day
Excelchat Expert 29/04/2018 - 04:05
Take Care

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.