Leave cell empty even when there is a formula in it.

[smidge]

Hi there,

Its probably very simple question, but i can not work it out.

I am trying to design a simple worksheet so I can keep track of how much money my room mate has paid me and what she owes. She pays $142 a week rent plus $23 a month for internet.

Please open the attached workbook. You can see in E7 and 8 there is a red negative number. This is because my tenant hasn't paid me yet for those weeks (D7 & 8).

How can i get these cells to read $0 or leave the cell empty??

The reason why I need this to read $0 or nothing is because it is messing up my next calculation in D3 where it works out how much she has paid for our internet bill.

Thanking you in advance. And sorry if this is a really daft question. Its probably something really simple i have missed.

Thanks

Monique

[Palmetto]

In E4, copied down: =IF(D4=0,0,D4-142)

[bstubbs]

Although I can't open your spreadsheet, I use something like this : =+IF(ISBLANK(E7),"",e7). Play with that type of formula to have it do the two varients that you need. HTH.

Bob

[martindwilson]

=+IF whats the + for?

[teylyn]

old habits die hard. Old Lotus 123 user ....

[smidge]

Thanks for your help so far. The reason you couldn't open it as it was saved as Excel 07. I have re-saved and is now attached....thanks

[teylyn]

have you tried Palmetto's suggestion? Do you need anything else?

[Palmetto]

Although I can't open your spreadsheet . . . . .

Bob

Get this

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 file formats

[smidge]

All done...thanks all

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save