testing
From: Juco (Me_at_nospam.fictional)
Date: 01/30/05
- Next message: KC: "Function in TextBo"
- Previous message: smags: "How do I have a list of possible answers auto put into a cell?"
- Next in thread: Dave Peterson: "Re: testing"
- Reply: Dave Peterson: "Re: testing"
- Reply: Ragdyer: "Re: testing"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 Jan 2005 22:46:09 GMT
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 sheet 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
- Next message: KC: "Function in TextBo"
- Previous message: smags: "How do I have a list of possible answers auto put into a cell?"
- Next in thread: Dave Peterson: "Re: testing"
- Reply: Dave Peterson: "Re: testing"
- Reply: Ragdyer: "Re: testing"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
