Because this formula calculate an exchange rate between two currency by
getting data from bloomberg and I use that formula in a matrix 180 by 180.

Something like that ... and I almost have not much space left.

¦ CHF ¦ GBP ¦ USD | SEK ¦ LIR | EUR ¦ GIP |
CHF
-----
GBP
-----
USD
-----
SEK
-----
LIR
-----
EUR
-----
GIP



Thanks Bob

"Bob Phillips" a écrit dans le message de news:
...
Can you humour me and tell me why not? By doing so, your formula would be
much more manageable.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nader" wrote in message
...
What I mean is that it should not be break.

thanks

"Bob Phillips" a écrit dans le message de news:
...
I've seen your formula, and you could easily.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nader" wrote in message
...
I can't break the formula.

"Bob Phillips" a écrit dans le message de
news:
...
Normally with long formulae, you can break them down by putting one
part
in
a separate cell and getting an interim result, and use that interim
result
within the next part. This can be done very effectively to get to
the
final
result.

For instance,

B1:
=IF(ISNA(VLOOKUP(A1,M1:P10,2,False)),"",VLOOKUP(A1 ,M1:P10,2,False))

Change this to

B1: =IF(ISNA(C1),"",C1)
C1: =VLOOKUP(A1,M1:P10,2,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nader" wrote in message
...
Hello,

I'm having a little problem, recently I wrote a formula for excel
which
is
too long so I have to decide between trying to find away too
shorten
that
formula (i'm not sure if it's possible) or written some of the
formula
code
in vba ?

However, I read in different website that If I wrote some code in
vba
it
will not be as efficient as a formula.

What should I do ? Shorten the formula or Vba code ?

PS : My data are consentenly updated because they are exchange
rates
(almost
every second)

Thank you all in advance.

Nader