| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW IS F3 USED WTH EXAMPLE
hi guys reply me soon
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
HOW IS F3 USED WTH EXAMPLE
Homework?
-- Don Guillett Microsoft MVP Excel SalesAid Software "dims" wrote in message ... hi guys reply me soon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
