How about

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MarkN" <MarkN@discussions.microsoft.com> wrote in message
news:B327FA5A-7775-44C6-94D8-FD91CB3E3706@microsoft.com...
> I was desparately trying to get back to this before somebody pointed out
that
> there are only 16 possible results. Thanks for your prompt response, but I
> need a formula that includes an answer for the other 15 scenarios. I am
going
> to do this with a VLOOKUP.
> --
> Thanks again,
> MarkN
>
>
> "Dav" wrote:
>
> >
> > if(and(d1="Y",e1="Y",f1="Y",g1="Y"),((((C1+2%)+3%)+4%)+5%),"")
> >
> > if you have only 4 Y/N options why are there 256 combinations? are
> > there not 2x2x2x2=16?
> >
> > Or am I missing something!
> >
> > Regards
> >
> > Dav
> >
> >
> > --
> > Dav
> > ------------------------------------------------------------------------
> > Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
> > View this thread:
http://www.excelforum.com/showthread...hreadid=555910
> >
> >