Explain the difference between the TRUE and FALSE parameters for the range_lookup argument of a VLOOKUP function. Give a business example of how you would use a VLOOKUP with a PMT function
What will be an ideal response?
In a VLOOKUP placing TRUE in the range_lookup argument allows the function to make an approximate match on a range of values. Placing FALSE in the range_lookup argument allows the function to make an exact match on a range of values. Using the PMT and VLOOKUP functions together is useful as the VLOOKUP function can retrieve an interest range from a range of possibilities while the PMT function calculates a payment based on the retrieved interest rate.
You might also like to view...
In fold boundary the key value is divided into parts whose size matches the size of the required address.
Answer the following statement true (T) or false (F)
A user ticket is opened when a user calls about an issue. __________
Answer the following statement true (T) or false (F)
Which of the following statements about cookies is not true?
A. Cookies obtain your personal information by searching your hard drive. B. Cookies are text files. C. Cookies help companies determine the traffic flow through their website. D. Some companies sell the personal information found in cookies to other companies.
Contrast is an important design principle that uses opposing elements, such as colors or lines, to produce an intensified effect in an image, page, or publication.
Answer the following statement true (T) or false (F)