Question about Computers & Internet

40kw*90%=36kw

I hope this information has been helpful.

Posted on May 26, 2011

Testimonial: *" great.cant beleive its that simple.just have to demonstrate the formula also.but this has helped clarify what that formula is.thanks.myles"*

How to appley class teacher goes to i1st hour class in asc time tablers

Posted on Jul 01, 2011

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

If you have a number in Cell A2 (say 100), and you put the amount of percentage increase or decrease in Cell A3 (say -10%), then put this formula into Cell A4 to calculate the answer:

=A2*(1+A3) , which then shows as the answer (90).

=A2*(1+A3) , which then shows as the answer (90).

Sep 05, 2014 | Microsoft Excel for PC

Correct a #N/A error
Show All
Hide All
This error occurs when a value is not available to a function or formula.

- Optionally, click the cell that displays the error, click the button that appears , and then click
**Show Calculation Steps**if it appears. - Review the following possible causes and solutions.
Missing data, and #N/A or NA() has been entered in its place

Replace #N/A with new data.

**Note**You can enter**#N/A**in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.

Giving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function

Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. Using the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table

By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.

Using an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula

If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).

Omitting one or more required arguments from a built-in or custom worksheet function

Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.

Using a custom worksheet function that is not available

Make sure that the workbook that contains the worksheet function is open and the function is working properly.

Running a macro that enters a function that returns #N/A

Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

The Casio FX-300MS does not provide base 2 logarithms as a single key operation. However, you can use the natural logarithm (ln, base e = 2.7182818...) and the formula

log2 ( x ) = ln( x ) / ln( 2 )

To calculate the base 2 logarithm of 16, key in

[ln] 16 [/] [ln] 2 [=]

and get displayed the correct answer 4.

The same simple formula also works for any other base, and actually for any other logarithms provided by your calculator. The FX-300MS also provides a logarithm to base 10 (lg). You could also

type

[lg] 16 [/] [lg] 2 [=] to get the solution to the problem above, or

[lg] 25 [/] [lg] 5 [=] to get the base 5 logarithm of 25.

log2 ( x ) = ln( x ) / ln( 2 )

To calculate the base 2 logarithm of 16, key in

[ln] 16 [/] [ln] 2 [=]

and get displayed the correct answer 4.

The same simple formula also works for any other base, and actually for any other logarithms provided by your calculator. The FX-300MS also provides a logarithm to base 10 (lg). You could also

type

[lg] 16 [/] [lg] 2 [=] to get the solution to the problem above, or

[lg] 25 [/] [lg] 5 [=] to get the base 5 logarithm of 25.

Mar 20, 2014 | Casio FX-300MS Calculator

Hi Dear, there are several solutions

ali_zulfikar@yahoo.com

9899780221

- In ms excel type a fraction formula and in tools--> formula auditing -->
- Please download offcemath.msi for MS Word 2007 from www.office.microsoft.com and install it.

its calculator part will show you the steps of solving fractions in insert--> equations-->maths. - Alternatively you can download microsoft math trial from www.microsoft.com this will show you all steps.

ali_zulfikar@yahoo.com

9899780221

Mar 04, 2009 | Core Learning Fractions Step-By-Step...

First think how you would solve this problem yourself on a piece of
paper. Then try programming it using the things you learned (if they've
given you this assignment without teaching you to multiply, subtract
and use if's, drop the course).

Well here is an idea.

Take the total kilowattage and send it to a function. What the function will do is subtract 14KW from the total Kilowattage and add the amount for the first 14KW then subtract 85KW from the total KW and add the amount for the 85KW. But once you subtract the number of KW from the total make sure to check if the total KW isn't negative, if so just break out of the function and return the total due.

Or if you have formula for how much the rate grows over how many miles.

For example lets say the rate grows by $1 every time the KW doubles you could have something like

int rate = 1; //Begining rate

int KW = 14; //First flat rate

int amount; //total amount they have to pay

while(totalKW > 0)

{

totalKW -= KW; //subtract the first rate

if(totalKW <= 0) //check if too much subtracted

break; //if so break

amount += rate; //add the rate to the total

rate += 1; // Add $1 to the rate every time

KW *= 2; // KW is doubled

}

Well here is an idea.

Take the total kilowattage and send it to a function. What the function will do is subtract 14KW from the total Kilowattage and add the amount for the first 14KW then subtract 85KW from the total KW and add the amount for the 85KW. But once you subtract the number of KW from the total make sure to check if the total KW isn't negative, if so just break out of the function and return the total due.

Or if you have formula for how much the rate grows over how many miles.

For example lets say the rate grows by $1 every time the KW doubles you could have something like

int rate = 1; //Begining rate

int KW = 14; //First flat rate

int amount; //total amount they have to pay

while(totalKW > 0)

{

totalKW -= KW; //subtract the first rate

if(totalKW <= 0) //check if too much subtracted

break; //if so break

amount += rate; //add the rate to the total

rate += 1; // Add $1 to the rate every time

KW *= 2; // KW is doubled

}

Jan 05, 2009 | Computers & Internet

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

¿ Oil heaters do not generate wattage. On the name plate for the unit it may give you an AMP draw. Multiply Amps times Volts to get wattage use when in operation.

May 01, 2008 | Heating & Cooling

the formulae for the surface area of round disc is

pi * r * r

where pi=3.14 and r =radious of disc= diametre/2

for this 1st u have 2 calculate the radious of the disc that is

180/2=90mm

then convert it to m by dividing 1000 ,so radious=90/1000=0.09 m

finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres

for 38 disc multiply 38 with the above area that is

0.025434 * 38=0.966492 sq metres

in excel 2007 u can do it more easily by going 2 formulas tab.

Under formla tab click on engineering formula and then convert

here u can convert from mm to m

after converting use the above formula i just told u.

pi * r * r

where pi=3.14 and r =radious of disc= diametre/2

for this 1st u have 2 calculate the radious of the disc that is

180/2=90mm

then convert it to m by dividing 1000 ,so radious=90/1000=0.09 m

finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres

for 38 disc multiply 38 with the above area that is

0.025434 * 38=0.966492 sq metres

in excel 2007 u can do it more easily by going 2 formulas tab.

Under formla tab click on engineering formula and then convert

here u can convert from mm to m

after converting use the above formula i just told u.

Feb 27, 2008 | Computers & Internet

If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.

B5 columns are filled with this:

=IF(A5>$B$1,($B$2*$B$1)+((A5-$B$1)*($B$3)),A5*$B$2)

NOTE: The $ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a $ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Please rate as FixYa! or ask please clarify. ThankYa!

B5 columns are filled with this:

=IF(A5>$B$1,($B$2*$B$1)+((A5-$B$1)*($B$3)),A5*$B$2)

NOTE: The $ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a $ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Please rate as FixYa! or ask please clarify. ThankYa!

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

392 people viewed this question

Usually answered in minutes!

×