Home |
Search |
Today's Posts |
#1
|
|||
|
|||
testing
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 |
#2
|
|||
|
|||
I posted this in the other threads:
I'm still confused at what you mean by clear. Do you mean your formula evaluates to ""? If yes, try this in M15: =sum(m7,m8,m13,m14) =sum() ignores cells with text. The add operator (+) likes to work with numbers and has trouble with text. Juco wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
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 he 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing duplicates testing in 2 coloms | Excel Worksheet Functions | |||
SUMIF testing two columns... | Excel Worksheet Functions |