If I have read your function correctly
=a1*80*b1*55*if(d1=”Y”,1.05,1) *if(e1=”Y”,1.05,1) *if(f1=”Y”,1.1,1)
*if(g1=”Y”,1.025,1)
Of course the 1.05 could be referenced by the cells which hold the
values in case you had to update them in the future, but if what you do
works, that’s all that matters
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