Reduse filesize

[Claus]

I trying to make my filesize smaller

I have cells like this:
=HVIS(ER.FEJL(LOPSLAG($C8;Priser;2;FALSK));"";LOPSLAG($C8;Priser;2;FALSK))
in english somthing like this
=if(is.error(llookup($C8;Priser;2;false));"";llookup($C8;Priser;2;false))
Filesize = 591 kB

I tried to reduse filesize by typing this:
=LOPSLAG($C7;Priser;2;FALSK)
English =llookup($C8;Priser;2;false)
Filesize = 592 kB

Why does it take up more and not less space ?

I've tried to change 20 cells and filesize is 593 kB

I have up to aprox. 2500 cells on one sheet where I could reduse like above.


Hoping for an answer.


Claus Persson

[Jordon]

Your file is a half a meg and you want to make it smaller?

"Claus" wrote
> I trying to make my filesize smaller
>
> I have cells like this:
>
=HVIS(ER.FEJL(LOPSLAG($C8;Priser;2;FALSK));"";LOPSLAG($C8;Priser;2;FALSK))
> in english somthing like this
> =if(is.error(llookup($C8;Priser;2;false));"";llookup($C8;Priser;2;false))
> Filesize = 591 kB
>
> I tried to reduse filesize by typing this:
> =LOPSLAG($C7;Priser;2;FALSK)
> English =llookup($C8;Priser;2;false)
> Filesize = 592 kB
>
> Why does it take up more and not less space ?
>
> I've tried to change 20 cells and filesize is 593 kB
>
> I have up to aprox. 2500 cells on one sheet where I could reduse like
above.
>
>
> Hoping for an answer.
>
>
> Claus Persson
>
>

[Claus]

Hi Jordon

I only have a few sheets right now, but i'm gonna have a lot. My first test
shows a final filesize at aprox. 4-5 MB.

Claus

"Jordon" <[email protected]> skrev i en meddelelse
news:[email protected]...
> Your file is a half a meg and you want to make it smaller?
>
> "Claus" wrote
>> I trying to make my filesize smaller
>>
>> I have cells like this:
>>
> =HVIS(ER.FEJL(LOPSLAG($C8;Priser;2;FALSK));"";LOPSLAG($C8;Priser;2;FALSK))
>> in english somthing like this
>> =if(is.error(llookup($C8;Priser;2;false));"";llookup($C8;Priser;2;false))
>> Filesize = 591 kB
>>
>> I tried to reduse filesize by typing this:
>> =LOPSLAG($C7;Priser;2;FALSK)
>> English =llookup($C8;Priser;2;false)
>> Filesize = 592 kB
>>
>> Why does it take up more and not less space ?
>>
>> I've tried to change 20 cells and filesize is 593 kB
>>
>> I have up to aprox. 2500 cells on one sheet where I could reduse like
> above.
>>
>>
>> Hoping for an answer.
>>
>>
>> Claus Persson
>>
>>
>
>