numbers formula
Is there a formula to automate: time value input into column a cells 30min, 45min, 60min, 90min that will input a dollar value into adjacent column b cells $50, $68, $85, $125?
iOS 5.1.1, numbers
Is there a formula to automate: time value input into column a cells 30min, 45min, 60min, 90min that will input a dollar value into adjacent column b cells $50, $68, $85, $125?
iOS 5.1.1, numbers
Hi choopid
Here is one way.
A Lookup table that lists the costs, and a Cost table that shows a close match when you enter a value (number of minutes) in A2. You can "hide" (move) the Lookup table to another Sheet (Tab) if you want.
Formula in B2 of the Cost table
=VLOOKUP(A2,Lookup::A:B,2)
If you want an exact match, the formula is
=VLOOKUP(A2,Lookup::A:B,2,0)
but that will show a red error triangle if there is no exact match to the number of minutes in A2
From the Function Browser:
VLOOKUP compares a search value to the values in the leftmost column of a specified collection. Unless an exact match is required, the row containing the largest left-column value that is less than or equal to the search value is selected. Then, the value from the specified column in that row is returned by the function. If an exact match is required and none of the leftmost-column values match the search value, the function returns an error.
Regards,
Ian.
numbers formula