Hide values where input has not been entered EXCEL 2003

[Pccoordinator]

Office 2003: I want to hide values in a cell that has no numbers in the cells it is pulling the formulas from.

I have a calculation "=B8+(1.6*(B14-100)/100)" that shows a value "-1.6" when no input has bee put in cells B8 or B14. I want the cell to show nothing if BOTH B8 and B14 have no numbers in them.

 

[SkipVought]

Hi,

You don't want to HIDE anything. That term is used to hide a column or row.
[tt]
=if(isblank(B8+(1.6*(B14-100)/100)),"",B8+(1.6*(B14-100)/100))
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Pccoordinator]

Thanks Skip,

For some reason the statement you gave me had no effect on the value displaying in the cell. I'm not sure what happened I cut and pasted it right from the this site??

 

[SkipVought]

try this
[tt]
=IF(OR(ISBLANK(B8),ISBLANK(B14)),"",B8+(1.6*(B14-100)/100))
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Pccoordinator]

Sorry, same result

 

[GlennUK]

Hi Pccoordinator,

make up your mind, 'cos you said ...

I have a calculation "=B8+(1.6*(B14-100)/100)" that shows a value "-1.6" when no input has bee put in cells B8 or B14. I want the cell to show nothing if BOTH B8 and B14 have no numbers in them.

which says in one part of the quote "when no input has been put in cells B8 OR B14" , and then later you say "if BOTH B8 AND B14 have no numbers in them".

Now I'd guess that you mean the latter ( based on looking at your formula ), so try ...

=IF(AND(ISBLANK(B8),ISBLANK(B14)),"",B8+(1.6*(B14-100)/100))

Glenn.

 

[Pccoordinator]

GlenUK,

You were right in your assumption, however the statement did not work.

Thanks for your help though.

 

[SkipVought]

Please explain in PAINFUL DETAIL what you want to happen.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Pccoordinator]

I have a formula in cell F11 that takes data from B8 and B14.
This spreadsheet calculates per the formula and puts the end result in F11.

I don't want anything to show in cell F11 until both cells B8 and B14 had numbers in them.

 

[SkipVought]

[tt]
=IF(OR(ISBLANK(B8),ISBLANK(B14)),"",B8+(1.6*(B14-100)/100))
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Pccoordinator]

Are you getting this formula to work on a spreadsheet of your own?

It is still putting -1.6 in the cell although the font seems different.

thanks

 

[SkipVought]

if either B8 or B14 is BLANK (NO SPACES)

if there is a ZERO 0 in each, you will get -1.6



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Pccoordinator]

Bravo!! that did it.

Thanks a bunch.

Ed