Formula Help

culprit

New Member
Joined
May 4, 2002
Messages
2
What is the formula for limited and specific conditions to return a specific result?
Example:
Column A Column B
(IF)15.90 = 16.02
(IF)37.50 = 45.48
. . .
There are only 11 conditions (prices) for my particular report and percentages will not work because results are based on different conditions (shipping costs, weight, labor, etc.)
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Not exactly sure what your attempting to do , though I thing an array formaul will do the trick. If you give me a little better example I might be able to give you the exact array formula required
 
Upvote 0
It sounds like you know what the 11 *returns* should be. You might want to create a table on another worksheet, then do a vlookup to that table to have it return the desired value.

Need help with VLOOKUP? It's ALL over this site if you do a search.

You can also download a sample VLOOKUP with instructions at:
http://www.thewordexpert.com/tipwarez.htm#MyVlookup
 
Upvote 0
On 2002-05-05 09:05, culprit wrote:
What is the formula for limited and specific conditions to return a specific result?
Example:
Column A Column B
(IF)15.90 = 16.02
(IF)37.50 = 45.48
. . .
There are only 11 conditions (prices) for my particular report and percentages will not work because results are based on different conditions (shipping costs, weight, labor, etc.)

=VLOOKUP(A2,{15.90,16.02;37.50,45.48;...},2,0)

would do. you can even put a 2-column list somewhere, and refer to that list as in

=VLOOKUP(A2,List,2,0)

where List the name that you assign to the range of cells that houses the 2-column list.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,148
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top