| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display number only if entered in a cell
Hi,
I am trying to display data with a IF function saying, that if greater than 0 then display this formula, if false then show " ". However, I need to display the number 0 if enterd in the cell as it is combined with other cells showing a cumulative number. =IF('Page 2'!K20+'Page 2'!L200;'Page 2'!K20+'Page 2'!L20;" ") How do if use the IF function to show data ONLY if it has been entered in a cell and can of course be the no. 0. Jacob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to display a number when a specific text is entered | Excel Discussion (Misc queries) | |||
| Number entered isn't number recorded in cell. | Excel Discussion (Misc queries) | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Discussion (Misc queries) | |||
| Display Row Borders When Text entered in Any Cell | Excel Discussion (Misc queries) | |||
| Cell contents don't display everything entered? | Excel Discussion (Misc queries) | |||
Threaded Mode
