multiple if functions

  1. I

    How to merge two formulas in to one formula

    Hello Excel specialists, I have two formulas I would like to merge: First formula =IFERROR(VLOOKUP($A8,List2!A:T,9,0),"Value not found") This formula is checking if cell value of A8 exists in List 2 Second formula =IF(ISBLANK(VLOOKUP($A8,List2!A:T,9,0)),"Empty",VLOOKUP($A8,List2!A:T,9,0))...
  2. J

    Using list boxes to display distance data with multiple IF AND statements

    This is not about Nested IF statements. Hi I am trying to output data values when 2 list box selections are true. ie. List box 1 = Player position - Left Forward Pocket -Full Forward -Right Forward Pocket etc... List box 2 = Venue -Adelaide Oval -Bellerieve Oval -Carrara etc... When: List...
    • James84
    • Thread
    • box if and statements list list box multiple if functions
    • Replies: 10
    • Forum: Excel Questions
  3. O

    Formula for extracting data from a table

    Hi experts! I need a bit of help with a tricky formula I'm trying to get done. Basically, in cell A2, I'm going to be entering a number and that needs to correspond to a table of prices I have. If the number is between: 0-75,000, it needs to be 478.8 75,001-125,000 it should be 634.8...
  4. C

    Multip IF Arguments, Average, and Disregarding cells with #DIV/0!

    I am attempting to average cells from an assessment model which uses an ordinal scoring system. 0-15 = N, 16-50=P, etc. I average the results from different focus areas. The focus areas contain a range of cells that include rows and columns. There are seven focus areas being assessed. I am...
  5. K

    multiple if functions-- Help please

    I have a spread sheet with multiple price classes for products.. I don't quite know how to word what exactly I'm trying to do.. Here goes ... I need to make a fuction that; if I have a price="price class" then price x "price discount" then for all the price classes. I have multiple price...

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