$10.00

  1. M

    show zero value

    <colgroup><col width="101" span="6" style="width:76pt"> </colgroup><tbody> POINTS BAGS WIN WE WE THEY TOTAL WE LOSS TOTAL 392 568 ($17.60) ($4.00) ($10.00) ($63.20) 551 427 $12.40 ($4.00) $10.00 $36.80 576 378 $19.80 $12.00...
  2. T

    Need help with an IF/THEN formula to include AND in addition to a date lookup

    I am new to this forum, so I apologize if this question has already been addressed. Here is what I am attempting to do: IF the content of cell "A" AND the date (the year only) in cell "B" THEN the content of cell "C" is inserted into cell "D". An example: "B" "A" "C"...
  3. S

    If Statement formula issue without picture issue lol

    Hi all, Last week I was completely stuck with this concept and Kweaver helped me out with this awesome formula, but since then I needed to modify the formula to add another condition and now I cannot get the formula to make S2 = 0 is the other conditions are "Non-Billable" and "No". Below is...
  4. S

    Nesting IF?

    <tbody> Billable / Non-Billable Electronic / Mail Page Cost search Fee Y/N Search Fee PDF Postage Total Billed Billable Mail $$ Y $10.00 $6.50 $$ =$$ Billable Electronic - Y $10.00 $6.50 - =$$ Non - Billable Mail or electronic 0 N - - =$0 Non- Billable...
  5. S

    VBA Regular Expressions Find and Replace

    I am trying to mimic a text editor that I am using for regular expressions in VBA. The text editor I am using is Sublime. I have a bunch of phrases and the numeric values I would like to put a dollar sign in front if I do not already have one. for example: I have this: The $40.00 dollar amount...
  6. M

    Need to Match columns

    Hi all, I have a very large spreadsheet (7000+ rows). Column B contains various Customer Names that repeat (column name: CUSTNMBR) Column K contains the Unit Price of each invoice (column name: UNITPRCE) I need to know which customers show a unit price of $0.00 AND $10.00. Can anyone...
  7. J

    Look up cell in a vlook up then retrieve cell next to it

    <tbody> A B C D E F G 1 JOB Operator 1 2 Current rate $10.00 3 Next Rate 4 Max Rate 1 5 Operator 1 12.00 9.00 9.75 10.50 12.00 6 Operator 2 15.00 10.00 12.00 14.00 15.00 7 Operator 3 13.00 8.50 10.25 12.00 13.00 8...
  8. A

    VBA to Transpose Data and Loop

    Hello Excel Gurus, I'm trying to write a code that will transform my data from singular columns to multiple rows. My data is currently organized like this; <tbody> Index Budget View 1/1/2018 2/1/2018 3/1/2018 4/1/2018 123 Budget $10.00 $10.00 $10.00 $10.00 123 Forecast $10.00 $0.00 $5.00...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top