| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I insert a true blank inst. of a non-blank zero string
I have an if formula that gives a calcualted value based under the condition
that there is proper values to calcualte from. If that condition is false I give a "". But since Excel don't consider "" as a blank it is put on top when I sort the data. Is it possible to insert a true blank instead of "" in the formula? My formula =IF(A1;IF(B1;A1/B1;"");"") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I insert a true blank inst. of a non-blank zero string
No.
-- David Biddulph "MF" wrote in message ... I have an if formula that gives a calcualted value based under the condition that there is proper values to calcualte from. If that condition is false I give a "". But since Excel don't consider "" as a blank it is put on top when I sort the data. Is it possible to insert a true blank instead of "" in the formula? My formula =IF(A1;IF(B1;A1/B1;"");"") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I insert a true blank inst. of a non-blank zero string
You could replace the formulas with an alternative, do the sort and then replace
the formula with what you want: =IF(A1;IF(B1;A1/B1;"zzzzzz");"zzzzzz") Sort the data and then change the formula back. (Use a string that will put it at the bottom.) MF wrote: I have an if formula that gives a calcualted value based under the condition that there is proper values to calcualte from. If that condition is false I give a "". But since Excel don't consider "" as a blank it is put on top when I sort the data. Is it possible to insert a true blank instead of "" in the formula? My formula =IF(A1;IF(B1;A1/B1;"");"") -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank cells: ISBLANK = FALSE, ISTEXT = TRUE | Excel Worksheet Functions | |||
| Formula to return a true blank | Excel Worksheet Functions | |||
| An if statment tat returns a true blank | Excel Worksheet Functions | |||
| Have a formula yield a true blank that disconnects graph line | Charts and Charting in Excel | |||
| Return blank cell if 'find' statement not true | Excel Worksheet Functions | |||
Linear Mode
