Need to hide the error

K

koji

Hi ... I guess this is always going to be a problem fo me.
So sorry for asking for help like this many times. I have
this formula here:
=SUMPRODUCT(ROUND(F8*4,0)/4)
that keeps giving me this "#VALUR!" error when nothing is
being entered, of course this can be very annoying when
presented and I want to know if anyone can help me, and
actualy explain to me how it was done. Just a little info
since I really want to tackle this problem on my own next
time.

Thanks again in advance. I really appreciate it.
Koji
 
F

Frank Kabel

Hi
first you don't need SUMPRODUCT for this formula. The
following should be sufficient:
=ROUND(F8*4,0)/4

Also if F8 is empty this formula will return '0'. So you
won't receive an error unless F8 contains a text value or
a Space
 
K

koji

Hi Frank,
Glad to hear from you again. Thanks for reply and all your
help so far. Actually the problem is that F8
contains a formula that goes something like this:
=IF(ISNUMBER(E8),ROUND(E8*20,0)/20,"")
and then of course in colom E I have another formula
refering to colom C where the actual numbers are entered.
Thats why I receive an error when nothing is
entered in colom C. I dont know if this helps explain, but
this is my very messy system.

I mean I can do it like this, by changing the cells font
to white, then under Format / Cells / Number /
Custom, use: [Black]General. Which will hide the error. A
help I received last week. But I just need to know how to
do it the other way.


=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/
-----Original Message-----
Click to expand...

Hi
first you don't need SUMPRODUCT for this formula. The
following should be sufficient:
=ROUND(F8*4,0)/4
Also if F8 is empty this formula will return '0'. So you
won't receive an error unless F8 contains a text value or
a Space

=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/
Hi ... I guess this is always going to be a problem for
me.
So sorry for asking for help like this many times. I have
this formula here:
=SUMPRODUCT(ROUND(F8*4,0)/4)
that keeps giving me this "#VALUR!" error when nothing is
being entered, of course this can be very annoying when
presented and I want to know if anyone can help me, and
actualy explain to me how it was done. Just a little info
since I really want to tackle this problem on my own next
time.

Thanks again in advance. I really appreciate it.
Koji
 
F

Frank Kabel

Hi
change your formula to something like the following:
=IF(ISNUMBER(F8),ROUND(F8*4,0)/4,"")

-----Original Message-----
Hi Frank,
Glad to hear from you again. Thanks for reply and all your
help so far. Actually the problem is that F8
contains a formula that goes something like this:
=IF(ISNUMBER(E8),ROUND(E8*20,0)/20,"")
and then of course in colom E I have another formula
refering to colom C where the actual numbers are entered.
Thats why I receive an error when nothing is
entered in colom C. I dont know if this helps explain, but
this is my very messy system.

I mean I can do it like this, by changing the cells font
to white, then under Format / Cells / Number /
Custom, use: [Black]General. Which will hide the error. A
help I received last week. But I just need to know how to
do it the other way.


=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/
-----Original Message-----
Click to expand...

Hi
first you don't need SUMPRODUCT for this formula. The
following should be sufficient:
=ROUND(F8*4,0)/4
Also if F8 is empty this formula will return '0'. So you
won't receive an error unless F8 contains a text value or
a Space

=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/
Hi ... I guess this is always going to be a problem for
me.
So sorry for asking for help like this many times. I have
this formula here:
=SUMPRODUCT(ROUND(F8*4,0)/4)
that keeps giving me this "#VALUR!" error when nothing is
being entered, of course this can be very annoying when
presented and I want to know if anyone can help me, and
actualy explain to me how it was done. Just a little info
since I really want to tackle this problem on my own next
time.

Thanks again in advance. I really appreciate it.
Koji
.
Click to expand...
 
K

Koji

Thank you very much for your help.
koji
-----Original Message-----
Hi
change your formula to something like the following:
=IF(ISNUMBER(F8),ROUND(F8*4,0)/4,"")

-----Original Message-----
Hi Frank,
Glad to hear from you again. Thanks for reply and all your
help so far. Actually the problem is that F8
contains a formula that goes something like this:
=IF(ISNUMBER(E8),ROUND(E8*20,0)/20,"")
and then of course in colom E I have another formula
refering to colom C where the actual numbers are entered.
Thats why I receive an error when nothing is
entered in colom C. I dont know if this helps explain, but
this is my very messy system.

I mean I can do it like this, by changing the cells font
to white, then under Format / Cells / Number /
Custom, use: [Black]General. Which will hide the error. A
help I received last week. But I just need to know how to
do it the other way.


=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/
-----Original Message-----
Click to expand...

Hi
first you don't need SUMPRODUCT for this formula. The
following should be sufficient:
=ROUND(F8*4,0)/4
Also if F8 is empty this formula will return '0'. So you
won't receive an error unless F8 contains a text value or
a Space

=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/=/
-----Original Message-----
Click to expand...

Hi ... I guess this is always going to be a problem for
me.
So sorry for asking for help like this many times. I have
this formula here:
=SUMPRODUCT(ROUND(F8*4,0)/4)
that keeps giving me this "#VALUR!" error when nothing is
being entered, of course this can be very annoying when
presented and I want to know if anyone can help me, and
actualy explain to me how it was done. Just a little info
since I really want to tackle this problem on my own next
time.

Thanks again in advance. I really appreciate it.
Koji
.
Click to expand...
.
Click to expand...
 
Top