View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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