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

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

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

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

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