| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display number only if entered in a cell
Sounds like you want to check to make sure a number has been entered.
=IF(AND(ISNUMBER('Page 2'!K20),ISNUMBER('Page 2'!L20),'Page 2'!K20+'Page 2'!L200),'Page 2'!K20+'Page 2'!L20,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JW" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display number only if entered in a cell
=IF(AND(COUNT('Page 2'!K20:L20)=2,'Page 2'!K20+'Page 2'!L200),'Page
2'!K20+'Page 2'!L20,"") -- Biff Microsoft Excel MVP "Luke M" wrote in message ... Sounds like you want to check to make sure a number has been entered. =IF(AND(ISNUMBER('Page 2'!K20),ISNUMBER('Page 2'!L20),'Page 2'!K20+'Page 2'!L200),'Page 2'!K20+'Page 2'!L20,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JW" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display number only if entered in a cell
Thank you for the below. It was in the ball park, but I had to play with it a
litte. I came up with: =IF(AND(ISNUMBER('Page 2'!K20);ISNUMBER('Page 2'!L20);'Page 2'!K20+'Page 2'!L20<" ");'Page 2'!K20+'Page 2'!L20;"") The.....L20<" "......seemed to make the formula work? Anyways, thanks for your speedily reply. "Luke M" wrote: Sounds like you want to check to make sure a number has been entered. =IF(AND(ISNUMBER('Page 2'!K20),ISNUMBER('Page 2'!L20),'Page 2'!K20+'Page 2'!L200),'Page 2'!K20+'Page 2'!L20,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JW" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display number only if entered in a cell
I'm curious...
'Page 2'!K20+'Page 2'!L20<" " What is the logic you're testing for in that expression? Here's what that means in "Excelese": If the sum of K20 + L20 is less than a space character... And in Excel, that will *always* be TRUE as long as K20+L20 returns *any* number. To see how that works try these formulas: =0<" " =10000000000<" " Both will return TRUE -- Biff Microsoft Excel MVP "JW" wrote in message ... Thank you for the below. It was in the ball park, but I had to play with it a litte. I came up with: =IF(AND(ISNUMBER('Page 2'!K20);ISNUMBER('Page 2'!L20);'Page 2'!K20+'Page 2'!L20<" ");'Page 2'!K20+'Page 2'!L20;"") The.....L20<" "......seemed to make the formula work? Anyways, thanks for your speedily reply. "Luke M" wrote: Sounds like you want to check to make sure a number has been entered. =IF(AND(ISNUMBER('Page 2'!K20),ISNUMBER('Page 2'!L20),'Page 2'!K20+'Page 2'!L200),'Page 2'!K20+'Page 2'!L20,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JW" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
