|Perhaps Mike's solution will work for you, but if not you'll need to supply more details.|
Keep in mind that we can't see your spreadsheet from where we're sitting so you need to be specific when explaining what you are trying to do. Cells references and the formulas that you are using would be helpful.
Without more details, I'm having trouble understanding what this means:
I have a sum which will calculate the 1 or 0 with another amount but I don't want the 1 or 0 to show.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.