Sorting Values using... LOOKUP?

[mescalante48]

Hello everyone, hope you can help.

what would be the formulas in C2 and D2

For C2: return A2 if B2<0 if not return 0
For D2: return A2 if B2>0 if not return 0

te result should look something like this, is LOOKUP the best option?

Gyazo

 

[BigBeachBananas]

I don't understand what you're trying to accomplish? Please provide more details.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1
2	16590	16.75	0	16590
3	16573.25	-16.75	16573.25	0
4	16580	11.75	0	16580
5	0	0	0	0
Main

Cell Formulas
Range	Formula
C2:C5	C2	=A2*(B2<0)
D2:D5	D2	=A2*(B2>0)

 

[mescalante48]

How about

+Fluff 1.xlsm
	A	B	C	D
1
2	16590	16.75	0	16590
3	16573.25	-16.75	16573.25	0
4	16580	11.75	0	16580
5	0	0	0	0
Main

Cell Formulas
Range	Formula
C2:C5	C2	=A2*(B2<0)
D2:D5	D2	=A2*(B2>0)

Yes, this is perfect, even though I'll like to understand how it works.

 

[Fluff]

This part (B2<0)returns either True or False & when you do a mathematical operation on it the True becomes 1 & False 0
So if B2 is a positive number (B2<0)returns False, so A2 is multiplied by 0

HTH

 

[mescalante48]

This part (B2<0)returns either True or False & when you do a mathematical operation on it the True becomes 1 & False 0
So if B2 is a positive number (B2<0)returns False, so A2 is multiplied by 0

HTH

Thank you so much for teaching.

 

[Fluff]

You're welcome & thanks for the feedback.