Exist a function to...

0

0xC00D11CD

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
 
P

Pete_UK

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
 
B

Bob Phillips

1) Just reference that cell

=A3

and format the same

2) =A3-B2

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
A

Arvi Laanemets

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)
 
Top