1. V

    Value Error

    Hi. This is quite simple but i just don't know how to get around it. The formula C+(A*B)-D C is essential in computation but often empty. this give me a value error if C is empty. What should be the right formula, not to get value error? Thanks
  2. Z

    Excel Formula - Work Hours Computation

    Hi, Good day! I hope you guys can help me with coming up with a formula for work hours computation. Here's the link for the spreadsheet: Thanks in advance!
  3. M

    Ratio Computation

    Hello guys i have a small laundry business, i want to know the ratio between the numbers of wash and the number of detergent used per day, i have i table like this <tbody>#DAE7F5[/URL] "] A B C D 1 Date Wash Detergent Ratio 2 August, 01 2018 6 4 3 August, 02 2018 5 3 4 August, 03...
  4. V

    modify formula

    Hi all and Happy New Year. i need help with these formula =IF(C6="","",AX6-AU6) if AT6 is empty. but if AT6 is not empty then computation will be AK2-AT6 thanks in advance for the help.
  5. K

    Formula to search code or letters in another cell and return it in different cell

    <tbody> A B C D E F G H I J K L M N O P G R S T U V 1 <tbody> Course code </tbody> COM 121 COM 122 COM 123 COM 124 2 CREDIT UNIT CW EX TS GRADE CW EX TS GRADE CW EX TS GRADE CW EX TS GRADE 3 NAME MATRIC. NO. <tbody> </tbody> <tbody> Column to...
  6. M

    Trying to retain data in one part of my worksheet which comes from formula in another part

    I have a worksheet setup to record household expenses and income (on a daily basis) and provide reporting at the same time. In part of the worksheet I record the daily expenses and income with totals at the bottom. I have very basic formula which adds up the daily amounts and gives a total for...
  7. R

    compute column a and column b and show result in column c

    Hi and Good day to all of you, I want to add 2 cells, lets say for example, take a look on the table below <tbody> Column A Column B Column C 2000 2 4000 1000 5 5000 200 6 1200 100 8 800 </tbody> As you can see, I want column C to render the product of column a and b, Take note that...
  8. J

    Computing business hours between dates

    Hi, Everyone, I am new to this and would like to seek your help computing the number of business hours between 2 dates. Given the following information: - Business Hours: 8am -5pm (8:00-17:00) - Business Days: Mon-Fri - if entry queued falls on a weekend or beyond the business hours, it...
  9. A

    Which bad practices/operations greatly slow down VBA macros?

    Hello I've been writing long, computationally expensive macros lately, and have noticed that VBA is considerably slower at certain types of computations than others. Copying/pasting, debug.prints, and Application.ScreenUpdating = True are some expensive operations that stand out to me. I was...
  10. E

    hh:mm:ss and mm:ss computations

    Can someone assist me with computations on the following worksheet? I need to do computations with times that may vary from hh:mm:ss and mm:ss. I have attached a photo of the spreadsheet. And I would like to do computations like this. I need to have all the...
  11. U

    ? x 13.3% = 10,000

    Hi, I want to use excel to compute the following: X______ (wages before 13.3% benefit pay) x 13.3% (benefit pay percentage) = 10,000 (total pay). I want to know what wages were before adding the 13.3% benefit pay using an excel formula. Thanks.
  12. A

    Most Difficult Problem with Numeric Cells?

    I have values in cells of Columns G and H (I got the values by COPY & PASTE SPECIAL, VALUE from website) which CANNOT be done calculations with, for example I cannot SUM() all values in Column G. Even changing the cells' format to NUMBER or GENERAL or TEXT cannot work. Pls HELP by giving me...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...