Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the Needs Tag column, enter a formula that displays Yes or No depending on whether the asset needs a property tag. The criteria for
In the Needs Tag column, enter a formula that displays Yes or No depending on whether the asset needs a property tag. The criteria for tagging is as follows: a. Asset purchased in current year (most recent full year). Use 2013 as the current year. b. Cost of asset is $3,000 or more. Each of these values are assumption data put into column B at top; the formula then references these values (absolute values). Both criteria must be met to place Yes in the Needs Tag column; otherwise place No. First, enter the current year in cell B2 and the Tag cutoff amount in cell B3. Use the information in cells B2 and B3 to develop an IF function in
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started