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'!L20>0;'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

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'!L20>0),'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'!L20>0;'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

=IF(AND(COUNT('Page 2'!K20:L20)=2,'Page 2'!K20+'Page 2'!L20>0),'Page
2'!K20+'Page 2'!L20,"")


--
Biff
Microsoft Excel MVP


"Luke M" <(E-Mail Removed)> wrote in message
news:B0D782DC-67B4-479C-817C-(E-Mail Removed)...
> 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'!L20>0),'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'!L20>0;'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

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'!L20>0),'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'!L20>0;'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

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" <(E-Mail Removed)> wrote in message
news:6256EAC2-A40A-46BF-9DA8-(E-Mail Removed)...
> 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'!L20>0),'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'!L20>0;'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