Question about The Computers & Internet

# Calculate the area of A1 cardboard - The Computers & Internet

Posted by on

×

my-video-file.mp4

×

## Related Questions:

### How to calculate an average on a cell by cell basis ?

In cell B1 put the formula =AVERAGE(A\$1:A1)
Copy the formula then paste it into cells B2 through B5000

You can use any other column, of course.

Jul 22, 2014 | Microsoft Excel Computers & Internet

### How do i calculate a difference in a percent?

If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will return 0.2. If the cell containing the formula is then formatted to display as percentage it will show as 20%.

Dec 13, 2013 | Microsoft Excel for PC

### 1.1 Calculate the equivalent resistor of the

Would you care to provide some details? Perhaps some diagrams to go with the questions?

Aug 30, 2013 | Televison & Video

### Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...

This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for \$15, which I'm sure you now realize after 10 days of trying.

Thanks
Tim

Sep 26, 2010 | Microsoft Excel for PC

### How to calculate an amount in cell up to a constant amount

Lets say you want Cell A1 is the number that you want to determin which column you want it to go in...try this formual you might need to tweek it or message back and tell me what you need ----First Column----- =IF(AND(500,000>=\$A1,\$A1>=0),A1," ")
----Second Column----- =IF(AND(2,000,000>=\$A1,\$A1>=500,001),A1," ")
-----Third Column---- =IF(AND(5,000,000>=\$A1,\$A1>=2,000,001),A1," ")
so this way it will only appear in the column that it fits in and you can replace A1 with the formula

Jun 25, 2009 | Microsoft Excel for PC

### Calculation of end date in format dd/mm/yy

Assuming you put the start date in cell A1, put this formula:

=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1))

in the cell where the result wanted to be appeared.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

### How do I calculate Turn around time in excel excluding sat & sun for 2009

It sounds like you want to determine the number of work days between two days? Use the NETWORKDAYS function. For example, if A1 is 1/4/09 and B1 is 2/4/09, =NETWORKDAYS(A1,B1) will be 23

Dec 18, 2008 | Microsoft Excel for PC

### Excel formulas

hello
yes it is.
example

sheet1
A1 (50)
A2 (50)

sheet2

(A1)=
"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain
in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?
dont know else how I should explain it...
good luck

Oct 09, 2008 | Microsoft Excel for PC

### Microsoft Excel Calculation

for example if your numbers are in cells A1, B1 and C1
=MIN(A1:C1)+MEDIAN(A1:C1)

only works for 3 numbers as you requested.

Sep 01, 2008 | Microsoft Excel 2000 Step by Step...

### Multiple arguments in excel

Okay, here's a possible solution--based on my interpretation of your problem.

Suppose you have some value in cell B1, and the month (either Jan, Feb, or Mar) is stored in cell A1. The formula in C1, which performs calculations based on which month appears in A1, is as follows:

=IF(A1="Jan",B1*0.25,IF(A1="Feb",B1*0.3,IF(A1="Mar",B1*0.4)))

In this example, the value in B1 is multiplied by .25 if the month is Jan, by .3 if it's Feb, and .4 if it's Mar.

Nov 09, 2007 | Computers & Internet

## Open Questions:

#### Related Topics:

24 people viewed this question

Level 1 Expert