Re post the exact formulas
 

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

"Ragdyer" wrote in message
...
I just came across your other posts from yesterday pertaining to this form
you're working up, where here, you're trying to total the formula help you
received yesterday.

Why not post here the exact formulas that you've decided to use from
yesterday's suggestions.
Describe the formula in each of the cells that you're looking to sum.
Makes it easier for the folks around here to HELP YOU !
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-


"Juco" wrote in message
k...
Try and explain better...
cells M7 to M14 are totaled in cell M15
If I delete the contents of cells M7 to M14 I get this message in cell
M15
#Value!
I think relating to the fact that the info in cells M7 to M14 doesn`t
now
show any values.
As soon as I put a no back in the cells the message disappears.

thanks

"Dave Peterson" wrote in message
...
How do you clear the cells.

I'm guessing you hit the spacebar. That doesn't clear the cell--it
puts
in a
space character. (It may look the same, but it's not.)

Try clearing the cells by hitting the delete key on the keyboard.
(or edit|clear|contents)

Juco wrote:

when i clear all the cells in the formula below I get #VALUE!
showing in
the cell (M15)
Is there a way to just show a blank cell? and not have this message
showing.

thanks

=M7+M8+M13+M14

--

Dave Peterson

I posted this in the other thread:

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

"Ragdyer" wrote in message
...
I just came across your other posts from yesterday pertaining to this form
you're working up, where here, you're trying to total the formula help you
received yesterday.

Why not post here the exact formulas that you've decided to use from
yesterday's suggestions.
Describe the formula in each of the cells that you're looking to sum.
Makes it easier for the folks around here to HELP YOU !
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-


"Juco" wrote in message
k...
Try and explain better...
cells M7 to M14 are totaled in cell M15
If I delete the contents of cells M7 to M14 I get this message in cell
M15
#Value!
I think relating to the fact that the info in cells M7 to M14 doesn`t
now
show any values.
As soon as I put a no back in the cells the message disappears.

thanks

"Dave Peterson" wrote in message
...
How do you clear the cells.

I'm guessing you hit the spacebar. That doesn't clear the cell--it
puts
in a
space character. (It may look the same, but it's not.)

Try clearing the cells by hitting the delete key on the keyboard.
(or edit|clear|contents)

Juco wrote:

when i clear all the cells in the formula below I get #VALUE!
showing in
the cell (M15)
Is there a way to just show a blank cell? and not have this message
showing.

thanks

=M7+M8+M13+M14

--

Dave Peterson

--

Dave Peterson

See other post.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Juco" wrote in message
k...
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

"Ragdyer" wrote in message
...
I just came across your other posts from yesterday pertaining to this
form
you're working up, where here, you're trying to total the formula help
you
received yesterday.

Why not post here the exact formulas that you've decided to use from
yesterday's suggestions.
Describe the formula in each of the cells that you're looking to sum.
Makes it easier for the folks around here to HELP YOU !
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-


"Juco" wrote in message
k...
Try and explain better...
cells M7 to M14 are totaled in cell M15
If I delete the contents of cells M7 to M14 I get this message in cell
M15
#Value!
I think relating to the fact that the info in cells M7 to M14 doesn`t
now
show any values.
As soon as I put a no back in the cells the message disappears.

thanks

"Dave Peterson" wrote in message
...
How do you clear the cells.

I'm guessing you hit the spacebar. That doesn't clear the cell--it
puts
in a
space character. (It may look the same, but it's not.)

Try clearing the cells by hitting the delete key on the keyboard.
(or edit|clear|contents)

Juco wrote:

when i clear all the cells in the formula below I get #VALUE!
showing in
the cell (M15)
Is there a way to just show a blank cell? and not have this
message
showing.

thanks

=M7+M8+M13+M14

--

Dave Peterson