c12

  1. T

    Multiple IF statements with Variables

    Trying to do the following. If B12 = "#3 Ham & Cheese" and C12 = "Regular", then J12 = 6.65 If B12 = "#3 Ham & Cheese" and C12 = "Mini", then J12 = 5.55 If B12 = "#7 Turkey & Cheese" and C12 = "Regular", then J12 = 7.65 If B12 = "#7 Turkey & Cheese" and C12 = "Mini", then J12 = 5.75 There are...
  2. C

    3 Vlookups from 2 Values

    Hello All, Sheet 1: I need cell E6 to return the correct amount based on two values 1st value is A6 the Model# 2nd value is C12 the Qty. If C12 is below 5 then the result is 0 If C12 = 6-7, then I need a lookup on Sheet 2 that searches Sheet 1’s A6 Model#, on Sheet 2: Column A list...
  3. L

    If/And Statement with Multiple Cells

    Hello Everyone. I am having a very difficult time with an If Statement. It has been a very long time since I have done this so I am a bit rusty. The calculation consists of the following, Cell H12 has the calculation/function, Cell C12 needs to be greater than Zero, and cell M5 needs to also be...
  4. J

    VBA Pop Up Form

    I have been working on a spreadsheet and I am no VBA expert so I always ask for some help. I want to create a macro button that will bring up a Pop up form to allow users to enter a PO number in a text field with the execution button of "Search" and after hitting search it will unlock the...
  5. R

    VBA to change a formula in a cell with a command button?

    I have this code started in C12 and continues down to C31...... =IF(ROW()<$D$4+12,$F$4-((($F$4-($F$4/$B$4))/($D$4-1))*(ROW()-12)),"") There's a few things going on here but essentially the value will "turn down" in division based on a value in B4 and Full Scale in F4. I was thinking how...
  6. D

    Creating Password Function in Code

    Hello, say I have this data set Apple (123) Banana(456) Carrot (789) Mango (222) Peach(333) Berry I want to have a cell say C12 be a cell where any number can be entered but it locks if a correct number corresponding to a fruit is entered and displays that fruit name in C11. If 123 is entered...
  7. D

    VBA to split out hyphen strings into comma delimited

    Hi, Is it possible to split a hyphen string into comma delimited. Example: From This <tbody> A1-10 J1D1_4-J1D1_7 C2, C4-C8, C12 </tbody> To This <tbody> A1, A2, A3, A4, A, A, A7, A8, A9, A10 J1D1_4, J1D1_5, J1D1_6, J1D1_7 C2, C4, C5, C6, C7, C8, C12 </tbody>
  8. K

    Picking value from a certain cell under certain conditions

    Hello! Sorry for the dumb name of the topic - I am a beginner in excel and I know not that much so it's difficult for me to define the issue here. I attached my excel file which I am referring to. It's kinda difficult to explain what I wanna do here but I will try. What I wanna do here, is...

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