| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set formula to display a data from a 5 columns table | Setting up and Configuration of Excel | |||
| Formula to display data if it meets multiple criteria | Excel Worksheet Functions | |||
| Display data from cells based on a formula | Excel Discussion (Misc queries) | |||
| Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
Linear Mode
