ignoring £0 total in cell

Hi

I am a excel novice and can't seem to find a solution to this problem, there's most likely a simple solution.

I want to calculate the total of N - M in L only if N is > £0,
If I have not got a selling price in N how can I make cell L show blank?
I have attached a sample of the sheet.

Thanks for any help you can offer

If your formula is =N1-M1, you can make that stay blank by changing it to this:

=if(N2<=0,"",N2-M2)

Hi
Thanks for your reply,
This is the code I have got at the moment

Please Login or Register  to view this content.

I cant seem to attach my sample excel sheet
Here is what it looks like
M -------- N --------- R
£1.13 --- £5.46 ------ £6.59
-£17.23--- £17.23----- £-

I dont want the -£17.23 amount to show
Thanks

Originally Posted by ace2302

Hi
Thanks for your reply,
This is the code I have got at the moment

Please Login or Register  to view this content.

I cant seem to attach my sample excel sheet
Here is what it looks like
M -------- N --------- R
£1.13 --- £5.46 ------ £6.59
-£17.23--- £17.23----- £-

I dont want the -£17.23 amount to show
Thanks

The Code sample above, what cell is that in?

You don't want -17.23 to appear? Is that your cell M3? What is the formula in that cell? Is it the R cell you're wanting to keep blank until M & N are filled in?

What are these columns? N= Price? M=Tax? R=Price+Tax? What is it?

Hi again
Sorry if I'm being dense, how do I attach my excel file so you can see what I amtrying to do? I am getting a error message when I try upload

Already suggested.

Read the Forum rules to learn how to upload and what size you can upload.