Questions & Answers for: a1 a2

...a2 cell A1 = B4 + B5 = 50 cell A2 = C4 + C5 = 60 cell A3 = 50 + C4+C5 = 110 The formula for A1 is: =SUM(B4,B5) A2 is: =SUM(C4,C5) A3 is: =SUM(A1:A2) To test this, put 25 in cell B4, 25 in cell B5, ...

Ad

Question about Excel for PC

2 Answers

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

Ad

...fit Yes only the A1's were difrant A2-A9 the motor's never realy changed A7 had a better chamchain tensioner but from A2 the motor never realy changed Note the is for ZX/GPZ900R motors and not ...

...A1 contains =A2 because A2 is a date. I need A1 to show the day for that date. I just want a certain cell to show OFF if it is a certain day. The one I know only works if I put in the day of week ...

Question about DC14 All floors Bagless Upright Cyclonic Vacuum

1 Answer

A1/A2 and B1/B2. Disconnect, then connect A1 to B2 and A2 to B1. vacuum===============A1 A2=======Plug ===============B1 B2=======Plug Switch to vacuum===============A1 B2=======Plug ===============B1

...     |   3On Cell C1 or other cell you like, try to type this formula=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))That's all, just IF and math ...

by type in Excel? If field A1 is the old value and A2 is the new value, then the formula for A3 (% change) is:=(A2-A1)/A1*100You can remove the *100 if you want to format the field to the Percent type

...A2 I take the number 19.00 from cell A1 and apply the formula =A1-0.75 resulting in a sum of $18.25 in A2 which I want to round down to $18.00 in cell A2. Did you ever try round? or press F1 for help ...

A2 - A1 --------- x 100 A1 Where A1 is the old amount and A2 is the new amount. In this case A1 is $170 000 and A2 is $180 000. Putting it into the formula, we get 180 000 - 170 000 ------------------

Question about Excel X for Mac

1 Answer

...a autofill in the column that contains the sequence number. i.e. Cell A1 value= 1 Cell A2 =A1+1 (value will be 2) If you auto-fill the entire column will sequence: =A2+1 (value will be

Not finding what you are looking for?

Ask a Question

Usually answered in minutes!

Popular Products

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Computers & Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...