Hide result

[GerryK]

Hi,
I'm looking for a way to not display my last value all the
way Column G when I use:
=IF(D5>0,(G4-D5),IF(E5>0,(G4+E5),IF(D5=0,(G4),IF(E5=0,
(G4),""))))copied down. I would like a way without using a
Conditional format on G D and E are always empty until an
entry is made.

My situaton is this:
In G4 I have 1000 (a balance cell)
In D5 I have 100 so G5 will be 900 (a debit)
In E6 I have 100 so G6 will be 1000 (a credit)
With this formula I see the entire Column G populated with
the last calculated balance.

All the numbers are confusing so a way to hide them would
be appreciated.

Thanks

 

[Norman Harker]

Hi Gerry!

This will leave your column G cell empty until entries are made in D
and E:

=IF(AND(D5="",E5=""),"",IF(D5>0,(G4-D5),IF(E5>0,(G4+E5),IF(D5=0,(G4),I
F(E5=0,(G4),"")))))

You've got some horrible duplicate possibilities in your formula. In
most entry situations it would produce no problems but...

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bernie Deitrick]

Gerry,

How about:

=IF(AND(D5="",E5=""),"",G4-D5+E5)

This shows a result when any entry is made. It's OK to add or
subtract blanks or zero values, so you don't need to check those
values prior to operating on them.

HTH,
Bernie
MS Excel MVP

 

[GerryK]

Thank you Norman!!!

I owe you an OBAN!

-----Original Message-----
Hi Gerry!

This will leave your column G cell empty until entries are made in D
and E:

=IF(AND(D5="",E5=""),"",IF(D5>0,(G4-D5),IF(E5>0,(G4+E5),IF (D5=0,(G4),I
F(E5=0,(G4),"")))))

You've got some horrible duplicate possibilities in your formula. In
most entry situations it would produce no problems but...

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.

 

[Norman Harker]

Hi Gerry!

If I'd known there was an OBAN available, I would have done some
surgery on your formula as well.

See Bernie's reply. He gets a double.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[GerryK]

2x OBAN!
Thank you for your time!

-----Original Message-----
Gerry,

How about:

=IF(AND(D5="",E5=""),"",G4-D5+E5)

This shows a result when any entry is made. It's OK to add or
subtract blanks or zero values, so you don't need to check those
values prior to operating on them.

HTH,
Bernie
MS Excel MVP




.