I am looking to create a Numeric Formula that sounds like this:

If [Text-Multiple Choice] equals "A", then calculate (40/[Number Field]-100),

If [Text-Multiple Choice] equals "B", then calculate (90/[Number Field]-100),

If [Text-Multiple Choice] is blank, then leave field blank

Any advice? I'm not sure if my issue is a syntax issue or using the wrong formula.

Thanks!

If [Text-Multiple Choice] equals "A", then calculate (40/[Number Field]-100),

If [Text-Multiple Choice] equals "B", then calculate (90/[Number Field]-100),

If [Text-Multiple Choice] is blank, then leave field blank

Any advice? I'm not sure if my issue is a syntax issue or using the wrong formula.

Thanks!