computation

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

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!

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

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.

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

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

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

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

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

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

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.

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