$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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top