Hi All

Is there a worksheet function to do this ?

I have in column AF 48 a formula as follows:
S48*AE48/100 down to 4000 rows , in some rows this formula returns a #VALUE!
error . Is there a worksheet function that will return an empty cell (no
formula just empty cell) instead of a #VALUE! error ?

thanks
regards bill
--
bill gras

Hi Roger,
Thank you for your reply.
Your function still leaves the formula in the cell. What I need is the cell
to be empty , because an other formula works on some of the cells to
be empty (no formula) , as if the content of the cell has been deleted.
This is what I need AF
48 11 :- =
IF(ISERROR(S48*AE48/100),"",S48*AE48/100)
49 7 :- =
IF(ISERROR(S49*AE49/100),"",S48*AE49/100)
50 2 :- =
IF(ISERROR(S50*AE50/100),"",S48*AE50/100)
51 5 :- =
IF(ISERROR(S51*AE51/100),"",S48*AE51/100)
52
53 13 :- =
IF(ISERROR(S53*AE53/100),"",S48*AE53/100)
so on down to 4000 rows
I hope you can help

regards bill
--
bill gras


"Roger Govier" wrote:

Hi Bill

One way
=IF(ISERROR(S48*AE48/100),"",S48*AE48/100)

Regards

Roger Govier


bill gras wrote:
Hi All

Is there a worksheet function to do this ?

I have in column AF 48 a formula as follows:
S48*AE48/100 down to 4000 rows , in some rows this formula returns a #VALUE!
error . Is there a worksheet function that will return an empty cell (no
formula just empty cell) instead of a #VALUE! error ?

thanks
regards bill

Hi Bill

I'm not sure I understand the layout of data you have posted.
However, you cannot have a formula that deletes itself if a condition is not
met.
The formula always has to be there.
The results of the formula are what you see.
In my example, a failure of the formula, rather than displaying an error
message, will display null "", but the formula will still be present in the
cell.

Give us an example of what you are trying to do with the results of these
cells and why the null value is giving you a problem and I or some other
member of the NG's may be able to come up with a solution for you.

Regards

Roger Govier


bill gras wrote:
Hi Roger,
Thank you for your reply.
Your function still leaves the formula in the cell. What I need is the cell
to be empty , because an other formula works on some of the cells to
be empty (no formula) , as if the content of the cell has been deleted.
This is what I need AF
48 11 :- =
IF(ISERROR(S48*AE48/100),"",S48*AE48/100)
49 7 :- =
IF(ISERROR(S49*AE49/100),"",S48*AE49/100)
50 2 :- =
IF(ISERROR(S50*AE50/100),"",S48*AE50/100)
51 5 :- =
IF(ISERROR(S51*AE51/100),"",S48*AE51/100)
52
53 13 :- =
IF(ISERROR(S53*AE53/100),"",S48*AE53/100)
so on down to 4000 rows
I hope you can help

regards bill

Hi Bill

One way
=IF(ISERROR(S48*AE48/100),"",S48*AE48/100)

Regards

Roger Govier


bill gras wrote:
Hi All

Is there a worksheet function to do this ?

I have in column AF 48 a formula as follows:
S48*AE48/100 down to 4000 rows , in some rows this formula returns a #VALUE!
error . Is there a worksheet function that will return an empty cell (no
formula just empty cell) instead of a #VALUE! error ?

thanks
regards bill