I am getting #Value! in a cell that has a formula of course
I pretty sure I know the problem but I dont know how to fix it
:)

in the Cell with the "#Value!" error is a simple formula =SUM(H12:I12)

In Cell H12 is a formula that is dependent on another cell for information
so its empty except for the formula
When information is placed in the cell H12 the "#Value!" error goes away and
it does its job

How do I hide that "#Value!" until the time when information is placed in H12

I hope I explained the situation correctly

Try this:

=IF(ISERROR(your_formula),"",your_formula)

--
Biff
Microsoft Excel MVP


"shallowz" wrote in message
...
I am getting #Value! in a cell that has a formula of course
I pretty sure I know the problem but I don't know how to fix it
:)

in the Cell with the "#Value!" error is a simple formula =SUM(H12:I12)

In Cell H12 is a formula that is dependent on another cell for information
so it's empty except for the formula
When information is placed in the cell H12 the "#Value!" error goes away
and
it does its job

How do I hide that "#Value!" until the time when information is placed in
H12

I hope I explained the situation correctly

I have no idea how you guys knows this stuff but it worked thank you very much

"T. Valko" wrote:

Try this:

=IF(ISERROR(your_formula),"",your_formula)

--
Biff
Microsoft Excel MVP


"shallowz" wrote in message
...
I am getting #Value! in a cell that has a formula of course
I pretty sure I know the problem but I don't know how to fix it
:)

in the Cell with the "#Value!" error is a simple formula =SUM(H12:I12)

In Cell H12 is a formula that is dependent on another cell for information
so it's empty except for the formula
When information is placed in the cell H12 the "#Value!" error goes away
and
it does its job

How do I hide that "#Value!" until the time when information is placed in
H12

I hope I explained the situation correctly

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"shallowz" wrote in message
...
I have no idea how you guys knows this stuff but it worked thank you very
much

"T. Valko" wrote:

Try this:

=IF(ISERROR(your_formula),"",your_formula)

--
Biff
Microsoft Excel MVP


"shallowz" wrote in message
...
I am getting #Value! in a cell that has a formula of course
I pretty sure I know the problem but I don't know how to fix it
:)

in the Cell with the "#Value!" error is a simple formula =SUM(H12:I12)

In Cell H12 is a formula that is dependent on another cell for
information
so it's empty except for the formula
When information is placed in the cell H12 the "#Value!" error goes
away
and
it does its job

How do I hide that "#Value!" until the time when information is placed
in
H12

I hope I explained the situation correctly

Hi,
try

=SUMIF(H12:I12,"<#Value!")

"shallowz" wrote:

I am getting #Value! in a cell that has a formula of course
I pretty sure I know the problem but I dont know how to fix it
:)

in the Cell with the "#Value!" error is a simple formula =SUM(H12:I12)

In Cell H12 is a formula that is dependent on another cell for information
so its empty except for the formula
When information is placed in the cell H12 the "#Value!" error goes away and
it does its job

How do I hide that "#Value!" until the time when information is placed in H12

I hope I explained the situation correctly