How to use an if statement to show if ANY value in the cell?
 

I have a spreadsheet that I am trying to seperate out into multiple ones. My
problem is, I may or may not need to have an account number show depending on
if there were transactions for it. Each account number could have 0 or many
different transactions. Is there anyway to do this? I was thinking of an if
statement something like...

=IF(Sheet2!C40-C81=(HERE IS PROBLEM...ANYTHING),C39,(0 or blank))

Please let me know if you have any suggestions!

How to use an if statement to show if ANY value in the cell?
 

I think I understand what you are asking. Instead of checking for = anything,
check for<"" or does not equal nothing.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Katie" wrote:

I have a spreadsheet that I am trying to seperate out into multiple ones. My
problem is, I may or may not need to have an account number show depending on
if there were transactions for it. Each account number could have 0 or many
different transactions. Is there anyway to do this? I was thinking of an if
statement something like...

=IF(Sheet2!C40-C81=(HERE IS PROBLEM...ANYTHING),C39,(0 or blank))

Please let me know if you have any suggestions!

How to use an if statement to show if ANY value in the cell?
 

I think I understand what you are asking. Instead of checking for = anything,
check for<"" or does not equal nothing.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Katie" wrote:

I have a spreadsheet that I am trying to seperate out into multiple ones. My
problem is, I may or may not need to have an account number show depending on
if there were transactions for it. Each account number could have 0 or many
different transactions. Is there anyway to do this? I was thinking of an if
statement something like...

=IF(Sheet2!C40-C81=(HERE IS PROBLEM...ANYTHING),C39,(0 or blank))

Please let me know if you have any suggestions!

How to use an if statement to show if ANY value in the cell?
 

=IF(Sheet2!C40-C81=(HERE IS PROBLEM...ANYTHING),C39,(0 or blank))

I'm guessing that "ANYTHING" means any number greater than 0. I'm also
assuming that you're dealing with only positive numbers? Try this:

=IF(Sheet2!C40-C81,C39,"")

Or:

=IF(Sheet2!C40-C81,C39,0)


--
Biff
Microsoft Excel MVP


"Katie" wrote in message
...
I have a spreadsheet that I am trying to seperate out into multiple ones.
My
problem is, I may or may not need to have an account number show depending
on
if there were transactions for it. Each account number could have 0 or
many
different transactions. Is there anyway to do this? I was thinking of an
if
statement something like...

=IF(Sheet2!C40-C81=(HERE IS PROBLEM...ANYTHING),C39,(0 or blank))

Please let me know if you have any suggestions!

How to use an if statement to show if ANY value in the cell?
 

=IF(Sheet2!C40-C81=(HERE IS PROBLEM...ANYTHING),C39,(0 or blank))

I'm guessing that "ANYTHING" means any number greater than 0. I'm also
assuming that you're dealing with only positive numbers? Try this:

=IF(Sheet2!C40-C81,C39,"")

Or:

=IF(Sheet2!C40-C81,C39,0)


--
Biff
Microsoft Excel MVP


"Katie" wrote in message
...
I have a spreadsheet that I am trying to seperate out into multiple ones.
My
problem is, I may or may not need to have an account number show depending
on
if there were transactions for it. Each account number could have 0 or
many
different transactions. Is there anyway to do this? I was thinking of an
if
statement something like...

=IF(Sheet2!C40-C81=(HERE IS PROBLEM...ANYTHING),C39,(0 or blank))

Please let me know if you have any suggestions!