Sort funktion

[heinrich3]

Hi
I want to seperate some numbers, but I can't find a solution.
If is in cell A1 the number 10 copy B1 and past it in C1
If is in cell A2 the number 20 or 30 or 40 copy B2 und past it in C2

Tank you for help Heinrich

[shg]

Welcome to the forum, heinrich.

That's more than a little cryptic -- how about an example workbook, and an explanation in context, mein Herr?

[protonLeah]

Using worksheet formulas,

If is in cell A1 the number 10 copy B1 and past it in C1
In C1:

=IF(A1=10,B1,"")
However, if A1 is other than 10, then C1 will be blank,
since you can only have a formula or a value, not both...

If is in cell A2 the number 20 or 30 or 40 copy B2 und past it in C2
In C2"

=IF(OR(A2=20,A2=30,A2=40),B2,"")

[heinrich3]

Thank you protonLeah, it works!