Dav,

Thanks very much for your post, and indeed it does work. I am always amazed
by how much there is about Excel that I don't know.

--
Thanks again,
MarkN


"Dav" wrote:


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, thats 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