R RagDyer Mar 30, 2004 #2 =A1-A2 OR =A2-A1 Is this what you need? -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== can some1 show me how to substract betwen 2 cells like a1 and a2.. thanks..
=A1-A2 OR =A2-A1 Is this what you need? -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== can some1 show me how to substract betwen 2 cells like a1 and a2.. thanks..
J JE McGimpsey Mar 30, 2004 #3 Select the cell you want to contain the difference, and type this in the formula box. = A2 - A1 and hit Enter.
Select the cell you want to contain the difference, and type this in the formula box. = A2 - A1 and hit Enter.
D Dave Hawley Mar 31, 2004 #4 Hi As you are obviously new to Excel, always try to avoid typing Cell addresses. The best way it to; Select the cell for the formula Type an = Now use you *mouse pointer* to select the needed cell. At this point you can push F4 to cycle through Absolute and Relative Cell References. Type the required operator, eg - + / * etc Use your mouse to select the other cell. ***** Posted via: http://www.ozgrid.com Excel Templates, Training & Add-ins. Free Excel Forum http://www.ozgrid.com/forum *****
Hi As you are obviously new to Excel, always try to avoid typing Cell addresses. The best way it to; Select the cell for the formula Type an = Now use you *mouse pointer* to select the needed cell. At this point you can push F4 to cycle through Absolute and Relative Cell References. Type the required operator, eg - + / * etc Use your mouse to select the other cell. ***** Posted via: http://www.ozgrid.com Excel Templates, Training & Add-ins. Free Excel Forum http://www.ozgrid.com/forum *****
