Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exist a function to...
Hi there,
i just started to use Exel 2003 and would realy appreciate if someone can help. Here are my two questions, 1) Is there a function if i type in a cell i for example 500£ that it will be displayed at the same time in other cells? 2) Is there a function to calculate currencies in different cells? As example A3 is 500£ and B2 is 300£. Now A3-B2 = 200£ , but i have to display the result in C4. Thank you in advance, Unal |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exist a function to...
1) Highlight the cells and click Format | Cells | Number tab - here you
have various ways of formatting the cells. Formatting does not change the value, merely how it appears on screen. 2) Enter this formula in C4: =A3 - B2 Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exist a function to...
1) Just reference that cell
=A3 and format the same 2) =A3-B2 -- HTH Bob Phillips (remove xxx from email address if mailing direct) "0xC00D11CD" wrote in message ... Hi there, i just started to use Exel 2003 and would realy appreciate if someone can help. Here are my two questions, 1) Is there a function if i type in a cell i for example 500£ that it will be displayed at the same time in other cells? 2) Is there a function to calculate currencies in different cells? As example A3 is 500£ and B2 is 300£. Now A3-B2 = 200£ , but i have to display the result in C4. Thank you in advance, Unal |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exist a function to...
Hi
To display the entry p.e. from cell A3 in another cell on same sheet, use the formula =A3 (probably you have to format the cell with formula too) To display the entry from another sheet, the formula (general form) will be: ='Sheet name'!A3 When the sheet name doesn't contain any spaces, you can use the formula =SheetName!A3 When referring to another sheet, and the source cell is empty, the link formula often returns 0. To avoid this, you can use the formula: =IF(SheetName!A3="","",SheetName!A3) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "0xC00D11CD" wrote in message ... Hi there, i just started to use Exel 2003 and would realy appreciate if someone can help. Here are my two questions, 1) Is there a function if i type in a cell i for example 500£ that it will be displayed at the same time in other cells? 2) Is there a function to calculate currencies in different cells? As example A3 is 500£ and B2 is 300£. Now A3-B2 = 200£ , but i have to display the result in C4. Thank you in advance, Unal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF function when 2 conditions exist? | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |