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" wrote in message
...
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