How to use OR with formulas

[Tyrel Smith]

Can someone help me please.

As you can see in cells B17 and C17 I have a size with a ± value of 0.30 and column D is for the lowest size(110.50 - 0.30) and Column E is for the highest size(110.50 + 0.30). The formula that I am using works perfectly but that is only if there is ± but sometimes I have only - or only +. So I tried to use an or function but I get an error and even if it did not give an error, it would only return true but in need it to be a value.

So if its a + then the lowest size should stay what it is(110.50) but increase the size by the given amount and insert it into the highest size column.
And if its a - then decrease the size by the given amount and insert it into the lowest size column and the highest size column must be == the size column.

 

[mart37]

Maybe you can use three IFERROR: IFERROR(search +,IFERROR(search -,IFERROR(search ±)))

 

[Tyrel Smith]

Maybe you can use three IFERROR: IFERROR(search +,IFERROR(search -,IFERROR(search ±)))

So how would I implement that?

 

[mart37]

Map1
	A	B	C
1	size	low	high
2	110,50 - 0,30	110,2	no
3	110,70 + 0,20	no	110,9
4	110,70 ± 0,21	110,49	110,91
Blad1

Cell Formulas
Range	Formula
B2:B4	B2	=IFERROR(LEFT(A2,FIND("-",A2)-1)-MID(A2,FIND("-",A2)+1,256),IFERROR(LEFT(A2,FIND("±",A2)-1)-MID(A2,FIND("±",A2)+1,256),"no"))
C2:C4	C2	=IFERROR(LEFT(A2,FIND("+",A2)-1)+MID(A2,FIND("+",A2)+1,256),IFERROR(LEFT(A2,FIND("±",A2)-1)+MID(A2,FIND("±",A2)+1,256),"no"))

 

[Tyrel Smith]

Map1
	A	B	C
1	size	low	high
2	110,50 - 0,30	110,2	no
3	110,70 + 0,20	no	110,9
4	110,70 ± 0,21	110,49	110,91
Blad1

Cell Formulas
Range	Formula
B2:B4	B2	=IFERROR(LEFT(A2,FIND("-",A2)-1)-MID(A2,FIND("-",A2)+1,256),IFERROR(LEFT(A2,FIND("±",A2)-1)-MID(A2,FIND("±",A2)+1,256),"no"))
C2:C4	C2	=IFERROR(LEFT(A2,FIND("+",A2)-1)+MID(A2,FIND("+",A2)+1,256),IFERROR(LEFT(A2,FIND("±",A2)-1)+MID(A2,FIND("±",A2)+1,256),"no"))

thank you very much