Jul 25 2022 06:04 PM - edited Jul 25 2022 06:05 PM
Jul 26 2022 08:15 AM
Well, I think this attached spreadsheet goes part of the way. There are drop-down lists for the two choices. Then, in cell B5, if the two choices are not blank Ii.e., both filled in), then the value 99 appears.
Beyond that, it wasn't clear to me what your sentence--Then I want the formula to be 99 = P1 + AA--means.
Are there values associated with P1, P2 etc, and with AA, and all the others? You haven't specified that. If so, there'd be a table lookup ...... come back and clarify and we can add that functionality. But maybe this is all the help you were seeking.