Questions & Answers for: Microsoft Excel e 60

...2. i want the result to be shown as = number + 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: ...

...bank bills Hi, I am considering borrowing using bank bills. e.g. Face value of 100,000 payable in 60 days and has a settlement cost of say 90,000. how do I create a formula to calculate the

...80),"4.0",IF(AND(C3>=75),"3.5",IF(AND(C3>=70),"3.0",IF(AND(C3>=65),"2.5"))))))) and I wana add (C3>=60),2.0 (C3<60).1.0 the formula I type containe an error... how Can I solve it ! You don't need the ...

multiply a value by a minimum amount 1 x 60 =240 2 x 60 =240 3 x 60 =240 4 x 60 =240 5 x 60 =300 6 x 60 =360 1 to 4 is multipy by 4, greater than 4 use actual number You need a cell to put these ...

how do i multiply a value by a minimum amount 1,2,3 or 4 x 60 = 240 5 or more, normal sum I you have a row with 6 values you can get the minimum number from that area. Example: A1: 6 A2: 8 A3: 3 A4: 9

convert time into seconds e.g 10:45:45 = seconds =A1*24*60*60 Format the cell with the formula as a number

...is just 1/10th of an hr.. to put it more easy, the time which you get, convert it into mins.. (1hr=60mins) and then divide by 60.. For eg: 3hrs = 180mins -> 180/60 = 3hrs 3hrs 20mins = 180+20mins -> ...

...is 10 (lower limit starting is 0) and upper limit is 80. Also plot in graphing. 64 62 52 50 70 60 55 20 25 48 35 55 55 47 64 42 36 50 30 53 51 63 58 50 60 54 33 48 40 76 61 46 65 65 15 45 58 40 ...