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
Can you paste your sample data so that i can help you better
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
its coming hang on please
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
Please do give good rating
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.