ExcelBanter - Formula help, display nothing if no data

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Formula help, display nothing if no data (https://www.excelbanter.com/new-users-excel/235808-formula-help-display-nothing-if-no-data.html)

MrJim005

Formula help, display nothing if no data

Hi
I want a cell to display nothing if there is no data in a certain cell..

4100 - 4200 + 99 = -1 / if nothing is in the cell for 4100 then the sum
returned should be nothing

=F8-F7+J8 - if nothing is in F8 the cell should display nothing.

Thank
You

Gord Dibben

Formula help, display nothing if no data

=IF(F8="","",F8-F7+J8)

If F8 could contain anything but a number

=IF(ISNUMBER(F8),F8-F7+J8,"")

Gord Dibben MS Excel MVP

On Fri, 3 Jul 2009 15:36:31 -0700, "MrJim005" wrote:

Hi
I want a cell to display nothing if there is no data in a certain cell..

4100 - 4200 + 99 = -1 / if nothing is in the cell for 4100 then the sum
returned should be nothing

=F8-F7+J8 - if nothing is in F8 the cell should display nothing.

Thank
You

Shane Devenshire[_2_]

Formula help, display nothing if no data

Hi,

You could use

=IF(F8,F8-F7+J8,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"MrJim005" wrote:

Hi
I want a cell to display nothing if there is no data in a certain cell..

4100 - 4200 + 99 = -1 / if nothing is in the cell for 4100 then the sum
returned should be nothing

=F8-F7+J8 - if nothing is in F8 the cell should display nothing.

Thank
You

All times are GMT +1. The time now is 08:44 PM.