Re: testing

From: Ragdyer (RagDyer_at_cutoutmsn.com)
Date: 01/31/05 

Date: Sun, 30 Jan 2005 17:13:49 -0800

I can see your answer to your original post on my news reader.
I posted a reply there, to your original thread.
I'll repeat it here:

Try this in M15:

=SUM(M7:M8,M13:M14)
OR
=IF(SUM(M7:M8,M13:M14),SUM(M7:M8,M13:M14),"") 

-- 
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Juco" <Me@nospam.fictional> wrote in message
news:RsdLd.19987$B5.8362@fe1.news.blueyonder.co.uk...
> My apologies for posting as a new post but for some reason when I reply to
> group its not getting there,  so sorry if this duplicates along the way..
>
> This is the formulas I am using....
> This in M15.......... M7+M8+M13+M14
> This in M7...........  =CHOOSE(MATCH(D7,{0;5;7;9},1),"",150,200,"")
> This in M8...........  =CHOOSE(MATCH(H7,{0;5;7;11},1),"",150,200,"")
>
> It is a form for renting properties if the renter puts in the dates inD7
and
> H7 then M7 and M8 calculate the rental for those weeks. The problem is if
I
> send a blank form with no dates entered it has #VALUE! where it would
> normally enter the total in M15,  the *** works ok its just messy
sending
> out a blank form with #VALUE! on it   what I would like is for those
`error
> messages` (#VALUE!) to disappear` if possible.
>
> I hope this is a bit clearer
> thanks
>
>