IF CONTAINS THEN ADD

KamenRider

Hi everyone,

I have here problem that gives me a null value. I hope someone could solve this.

The data type is string. Sample

Price

99-30+

99-04

Solution should be

99-30.5

99-04

my formula is IF CONTAINS([Price],"+") THEN ([Price]+0.5) ELSE [Price] ENDIF.

Can someone to please provide me the correct formula or solution.

Then after that we are going the extract the numbers after the dash. Sample

99-30.5 

99.04

Solution

30.5

04

Thanks,

Kamen

Qiu

@KamenRider 
Something like this?

1201-KamenRider.yxmd