Jan 27 2019 12:45 AM
Jan 27 2019 04:16 AM
Hi,
You may lookup your ranges and return related results as
=LOOKUP(A1,{0,200,300},{0.4,0.3,0.2})
Of course it's better not to hardcode values but use cell ranges.
Jan 27 2019 04:26 AM
Hi
I understand that you need to calculate the price or the cost after a specific percentage raise depending on a policy.
You can setup a table with the percentages and use something like VLookup function with the calculation formula to get the new price.
The VLookup formula may be like the following formula:
=VLOOKUP(A2,$I$6:$J$9,2)
I set up a sheet to help you apply this in your work domain.
You can find more about the VLookup function in the following link:
https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
:
Jan 27 2019 04:26 AM
Hi
I understand that you need to calculate the price or the cost after a specific percentage raise depending on a policy.
You can setup a table with the percentages and use something like VLookup function with the calculation formula to get the new price.
The VLookup formula may be like the following formula:
=VLOOKUP(A2,$I$6:$J$9,2)
I set up a sheet to help you apply this in your work domain.
You can find more about the VLookup function in the following link:
https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
: