If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HOW IS F3 USED WTH EXAMPLE
hi guys reply me soon
|
#2
|
|||
|
|||
HOW IS F3 USED WTH EXAMPLE
1) In A1 type a number such as 12%
2) With A1 still selected, in the Name box (box to left of Formula Bar) type the word taxrate and press Enter. You must press Enter for this to work! 3) Let's confirm that you have named the cell A1: click on cell D1, now click on cell A1. The name box should not display "taxrate". If not, repeat steps 2 4) In A2 type a number like 100 5) In B2 type =A2* and then tap the F3 key. A dialog box opens, select the entry "taxrate" and click the OK key. Another way is to double click the "taxrate" entry. Your formula has become =A2*taxrate best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "dims" wrote in message ... hi guys reply me soon |
#3
|
|||
|
|||
HOW IS F3 USED WTH EXAMPLE
Homework?
-- Don Guillett Microsoft MVP Excel SalesAid Software "dims" wrote in message ... hi guys reply me soon |
Thread Tools | |
Display Modes | |
|
|