Tuesday, October 6, 2009
forex world
Uh Oh!!! Where did all of those "0's" come from?Point to each of the cells D25, E25, F25 and G25. Notice, as you click on each cell and look at the screen, how C23 (the cell with the 2) "rolled" and became D23, E23, F23 and G23 (which are blank - this caused the "0's"). A blank times a number is a “0.”We want the 2 to be in each formula and not to "roll".To do this we utilize something called Absoluting or Anchoring.Go back to cell C25. Now we'll enter the formula again, but a little differently (to anchor the 2).Type-in a =C23 (or you could type = and point to C23). NOW, tap the F4 key. Notice, in the Edit bar at the top of the screen, that the =C23 changes to: $C$23. (This tells you that cell C23 is absoluted or anchored. The "$'s" indicate the absoluting.) Now finish the formula by typing in or pointing *C17 as before. Tap Enter.The formula should look like: =$C$23*C19Now copy the formula in cell C25 to cells D25, E25, F25 and G25 again. Your row 25 should look similar to the image below
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment