ExcelBanter - 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