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

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

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