Get instant live expert help on I need help with structured reference excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Create an unqualified structured reference in column G to determine the value of the inventory on hand and apply Accounting Number Format. To calculate the inventory on hand multiply the Unit Price and the Amount on Hand.
Solved by I. B. in 19 mins
formula problem - the conditional formatting not structured correctly
Solved by V. Y. in 24 mins
a. Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members do not receive a raise after every year of service, find an approximate match.
Solved by S. W. in 20 mins
7. To be a Group Leader, the staff member must either have more than 3 service years or be a college graduate.
In cell K2 enter a formula using the IF and OR functions, as well as structured references, to determine if Adam Moriarty can be a group leader.
a. The IF function should first determine if the staff member’s Service Years is greater than 3 OR if the staff member’s college graduate status is “Yes”. Remember to use a structured reference to the Service Years and the College Graduate columns.
.
Solved by O. J. in 26 mins
Need help in putting data into tabular form , from structured data
Solved by T. J. in 30 mins