| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returns "0"; How do I make it return nothing?
It's a very basic formula: it simply returns data from another worksheet in the workbook. However, if no data is entered in the cell a "0" will be inserted in any cell that references it. I tried IF with a space for value_if_true, like so: =IF('sheet1!A1'=0, , 'sheet1!A1') But that didn't work; it still returned "0". I then tried replacing the space with a non-breaking space (Alt + 0160); that returned an error. Any Ideas? ~Jonathan -- jonlandrum http://jonlandrum.com/about/ ------------------------------------------------------------------------ jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615 View this thread: http://www.excelforum.com/showthread...hreadid=533945 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a column equal a formula in Excel? | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| formula returns (correctly) a negative value | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Threaded Mode
