Nel post
*MarkN* ha scritto:

Let's suppose C1 contains the multiplied total of A1 and B1. D1, E1,
F1 and G1 contain either a "Y" or "N". If all four of these cells
contain a "Y", I need =((((C1+2%)+3%)+4%)+5%). Of course, there are
256 "Y" and "N" combinations.

I would appreciate any suggestions or advice, but would love a
workable solution!!

I'm not sure to have well understood what do you mean, but you can try this:

=((((C1+2%*(D1="Y"))+3%*(E1="Y"))+4%*(F1="Y"))+5%* (G1="Y"))

(and the combinationsof Y and N shoul be 2^4 so just 16... ;-) )


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy