Separate negative values ​​of positive values

[marreco]

Hi.

I need a formula to bring negative results in column "B"

and positive results in column "E"

data will be sought in the "Origin" and put on the "Result"

See my file
http://www.4shared.com/office/qcZHiV3c/Numbers.html

Thank you!

[FDibbins]

we prefer if you upload files here, rather than other websites, not every1 can access them

try this tho,
in B1 use =if(A1<0,A1,"")
in E1 use =if)A1>0,A1,"")

[marreco]

Hi.
exceed 1MB file, so I would not deposited here in the forum.

I tried to compress, but I temho WinRar, it seems to me that this format is not recognized by forum

See now
http://www.sendspace.com/file/9b3u1l

[FDibbins]

did you try my suggestion?

edit: my point is that some members are on a server that may not allow accessing file-hosting sites, so it may not matter where you put the file. there is normaly always a way to make the file smaller - reduce the number of rows, remove sheets not relevant to the question etc

[marreco]

Hi.

Sorry

I need the data one below the other
you need to see to understand my archive

[FDibbins]

ok well then hopefully some1 else will be able to help you

[Ace_XL]

Use these array formulas. Both need to be conifrmed with Ctrl+Shift+Enter

For negatives start with

Please Login or Register  to view this content.

copy down

For positives

Please Login or Register  to view this content.

Copy down

[icestationzbra]

non-array formulae...

in Result!B5:

Please Login or Register  to view this content.

in Result!E5:

Please Login or Register  to view this content.

[marreco]

Hi.
The formula of icestationzbra, attended me perfectly!

thanks to all