| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use an IF statement to show a picture? | Excel Discussion (Misc queries) | |||
| how can I change input statement to show only stars for password **** | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| What template is best to show an income and expense statement | Excel Discussion (Misc queries) | |||
| Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel | |||
Threaded Mode
