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.