0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
How do you find volume of trapezoid shaped RCC footing?
(a1+a2+sqrt(a1*a2)*h/3= volume of Trapezoid RCC Footing
When ac convert in dc then voltage will increase or decrease?
You can make it so it does either increase or decrease. The limiting factor is that power out cannot exceed power in. So going to a higher voltage will limit current and going to a lower voltage will increase current available. A2 Because AC is continuously changing in a sinusoidal waveform, it is hard to determine the exact voltage. It is usually called by it's RMS value (Root Mean Squared). The result is that when you fully rectify an AC voltage, the DC voltage is actually HIGHER than the RMS AC voltage.
How do you select contactor for motor?
With a contactor we can control the power connection to the motor (power on/off). A typical AC contactor comes with 4 terminals aside (L1,L2,L3,A). 'A' has A1,A2 terminals which are of the magnetizing coil. By magnetizing & demagnetizing A1-A2 coil, power line connections to motor can either be made or broken. This is a simple DOL (Direct On Line) application. Further, reverse/forward circuits and star-delta circuits can be constructed based on the requirement. A contactor's role in whatever application is 'making or breaking' the contact. The coil supply can either be AC or DC.
What is corresponding c plus plus expression of a2 plus b2?
int x = 2 * (a + b);
How do you do the summation of two matrix in c language?
#includevoid f1(int a[]);int a1[2][2],a2[2][2];int i,j;void main(){for(i=0;i
How you can 10 percent above in Excel?
To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2To add 10% of a value to itself in Excel, it could be done in several ways. Assuming the initial value is in A2, then you could do it in any of these ways:=A2*110%=A2*1.1=A2*10%+A2=A2*0.1+A2
What is the difference between min and max function?
The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.=MIN(A2:A20)=MAX(A2:A20)
How do you write code in visual basic to find data in a cell and return data from a cell next to it the range will change depending on the criteria entered?
It is not clear exactly what you would like to do, but try something like this in your worksheet code module: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$2" Then Exit Sub If Range("A2").Value > 0 Then Range("A2").Value = Range("A2").Value + Range("B2").Value Else Range("A2").ClearContents End If End Sub The value of A2 will update with =A2+B2 every time you change the value in A2.
How do you subtract 40 percent in Excel?
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:=B2-B2*10%=B2*90%=B2-B2*0.1=B2*0.9=B2/10*9
How do you convert a formula to zero if negative in Excel?
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.=IF(A2
What is the square function in Excel?
The square root function is SQRT, like this:=SQRT(value)To square a number, either multiply it by itself, using the POWER function or the power operator. If you had a value in cell A2, all of the following would do the same thing:=A2*A2=POWER(A2,2)=A2^2
How do you set up a formula for a balance to subtract a certain percentage from a number entered in a cell?
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.=A2*80%You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:=A2-A2*20%You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:=A2-A2*B2
What is a2 - 36?
a2-36=0 2a=36 a=36/2 a=18 Hence, the required value is a is 18.
What test is true or false in Excel?
Any logical test results in a true or false value, such as comparing things to see if they are the same or not. These are usually used within an IF function or some of the other logical functions. The following function would test a value in cell A2. IF(A2>10,"The cell A2 has a value greater than 10", "A2 is less than or equalled to 10")
Microsoft Excel abale to calculate moving average?
Yes, it can be done. The trick is to use absolute reference in your average formula. Say you have your figures in column A, with the first in A2, assuming you have a heading in A1. Then in B2 put the following formula: =Average(A$2:A2) That will give the Average of the first cell, which will of course be the value in A2. But as you copy the formula down column B, you will find it keeps averaging from A2 down to the current value beside the formula. So as the formula copies down, you get a running average. Using Sum, you can do the same thing to get a running total.
What function determines the lowest number in a range in Excel?
The MIN Function is the main way. If you wanted to find the smallest value in the range from cell A2 to cell A20, the formula would be:=MIN(A2:A20)You can also use the SMALL function, though it is normally used for find values that are not the actual lowest, but other low values, like the second or third lowest. The number used at the end is number position from the lowest value. So to get the lowest value you would use it this way:=SMALL(A2:A20,1)
Excel formula maximum and minimum value?
If you had a list of numbers in the cells from A2 to A20, you could find the highest and lowest values using the MAX and MIN functions as follows: =MAX(A2:A20) =MIN(A2:A20) You could also use the LARGE and SMALL functions in the ways shown below, though they are generally used for getting values like second largest or third smallest. In those cases you would change the 1 in the below examples to the appropriate values. =LARGE(A2:A20,1) =SMALL(A2:A20,1)
