| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=if returning 0
How do I write the following to show a blank in the cell, it is currently
returning a zer because the cell it is pulling from has a 0 value. =IF('Rep & Store Name Dump'!G108=C111,'Rep & Store Name Dump'!H108,"") Also, how do I write the following to return a blank, it is referringt o a blank cell =SNPT!C110 Thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returning #N/A Error---why??? | Excel Worksheet Functions | |||
| Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
