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