Convert joined text strings into a formula

I’m using a formula to pull real-time data into Excel for the probability of an event. I want to calculate the probability of the event NOT occurring using 1-[Probability of Occurrence]. The Probability of Occurrence is a long formula and I know I could build it like this:

=if(sign(D6)=1, 1-Probability of Occurrence formula, Probability of Occurrence formula)

But since Probability formula is long and complex, I wondered if I could simplify it something like this instead:

=if(sign(D6)=1, “1-“,”1*”) Probability of Occurrence formula result

But either I cannot find the right operators, syntax or it’s not possible. Anyone know the answer / know the solution?

Thanks, I appreciate any suggestions.

Perfect! I could have simplified a lot of formulas in the past if I'd have simply thought to ask that question! Thanks for the speedy reply too!

6StringJazzer/Rick,

Thanks for the additional suggestions – all work as desired.

Rick – just out of curiosity, is there a way to rewrite the “Choose” version that doesn’t required “P” to be entered twice? That’s was what I was trying to avoid since I wanted to shorten/simply the formula. The following are the formulas with the “P” replaced with the actual formulas which hopefully will make it clearer.

“One P”
=IF(SIGN(D6)=1,1,0) -SIGN(D6)*RTD("tos.rtd",,R$5,RIGHT($AC6,LEN($AC6)-IF(OR(LEN($AC6)<8,LEFT($B6,1)="/"),2,1)))

Or

=MAX(SIGN(D6),0) -SIGN(D6)*RTD("tos.rtd",,R$5,RIGHT($AC6,LEN($AC6)-IF(OR(LEN($AC6)<8,LEFT($B6,1)="/"),2,1)))

“Two Ps”
=CHOOSE(SIGN(D6)+2,RTD("tos.rtd",,R$5,RIGHT($AC6,LEN($AC6)-IF(OR(LEN($AC6)<8,LEFT($B6,1)="/"),2,1))),0,1-RTD("tos.rtd",,R$5,RIGHT($AC6,LEN($AC6)-IF(OR(LEN($AC6)<8,LEFT($B6,1)="/"),2,1))))

Thank you.