| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement
You can replace all "" with 0 (zeroes) and all & with +. This will keep the formula as it is (I mean without enclosing it in VALUE function). I'm just not sure if this solution meets all possible outcomes you may encounter. Check it out :) -- nCage ------------------------------------------------------------------------ nCage's Profile: http://www.excelforum.com/member.php...o&userid=29605 View this thread: http://www.excelforum.com/showthread...hreadid=493025 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement problem | New Users to Excel | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
Hybrid Mode
