=PRODUCT(D5,0.9,0.9)

ignores text

otherwise

=IF(D5="","",D5*0.9*09)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"bazza825" wrote in
message ...

Ok, this is what i have in the relevant cells...

D8
=IF(ISNA(VLOOKUP(A8,data!$C$2:$J$2971,3,FALSE)),"" ,VLOOKUP(A8,data!$C$2:$J$2971,3,FALSE))

E8
=SUM(D5*0.9*0.9)

Now if No data is entered in reference cell (A8), E8 just returns
#VALUE!, but i want it blank so the sheet is nice and tidy...
is this possible?

cheers again in advance
barry


--
bazza825
------------------------------------------------------------------------
bazza825's Profile:
http://www.excelforum.com/member.php...o&userid=33241
View this thread: http://www.excelforum.com/showthread...hreadid=537382