# computation

1. ### 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. ### 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: https://drive.google.com/open?id=1rZDYvB-KvGQFrFMuVjSQdYMDS-TxfzKm Thanks in advance!
3. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### hh:mm:ss and mm:ss computations

Can someone assist me with computations on the following worksheet? http://tinypic.com/r/2qlv1c4/7 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. ### ? 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. ### 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...

### This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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

### Which adblocker are you using?

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

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