Subtractic cells only with values

I want to subtract two cells in excel but only if both cells have a value. More exactly in this case C1 is currently =SUM(A1-B1), where A1 is my selling price and B1 is my buying price. C1 (my earnings) should be blank if either A1 or B1 don’t have a value.

As it is now, I can have a value in A1 and empty B1 and it will show me the total ammount of A1 in C1, although I need these fields in column C to be empty when one of A or B is missing.

Thanks

By: Carl

2,196 thoughts on “Subtractic cells only with values

  1. jual sitotek

    What’s up Dear, are you genuinely visiting this website on a regular basis, if so afterward you will without doubt get fastidious knowledge.

  2. Payday loans

    Excellent read, I just passed this onto a friend who was doing a little research on that. And he just bought me lunch as I found it for him smile Thus let me rephrase that: Thanks for lunch! “Bill Dickey is learning me his experience.” by Lawrence Peter Berra.

  3. https://iamgutsclub.com/

    I blog frequently and I really thank you for your information. This great article has really peaked my interest. I will bookmark your site and keep checking for new information about once a week. I opted in for your Feed too.

  4. udfauzi

    This is a really good tip especially to those new to the blogosphere. Simple but very precise info… Thank you for sharing this one. A must read article!

  5. App Tv Ao Vivo Gratis

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  6. moedah.com

    You’ve made some decent points there. I checked on the web for more information about the issue and found most people will go along with your views on this website.

  7. vivoslot login

    Good post. I learn something totally new and challenging on blogs I stumbleupon everyday. It’s always exciting to read through articles from other writers and practice something from their websites.

  8. vivoslot.online

    After going over a handful of the articles on your blog, I truly appreciate your way of blogging. I saved it to my bookmark website list and will be checking back in the near future. Take a look at my web site too and tell me how you feel.

  9. daftar akun vivoslot

    I’m amazed, I must say. Rarely do I come across a blog that’s both educative and entertaining, and without a doubt, you have hit the nail on the head. The problem is something that not enough people are speaking intelligently about. I am very happy I stumbled across this during my hunt for something relating to this.

  10. Pusat Sewa Bus

    The developer is trying in order to convince me to proceed to. net from PHP. I have always disliked the idea because associated with the expenses. But he is trying no less. I have been using Movable-type in several websites for regarding per year and am troubled about switching to an additional platform. I possess heard excellent things about blogengine. internet. Is there a method I can transfer just about all my WordPress posts in it? Any help would end up being appreciated.

  11. Houston Sleep Apnea Dentist

    I’m now not sure where you’re getting your info, but great topic.
    I needs to spend a while studying much more or understanding more.
    Thank you for magnificent info I used to be in search of this information for my mission.

  12. but trinh chieu PCMAX

    Hello just wanted to give you a quick heads up
    and let you know a few of the images aren’t loading
    properly. I’m not sure why but I think its a linking
    issue. I’ve tried it in two different web browsers and
    both show the same outcome.

  13. dingdongtogel.com

    Hi, I do think this is an excellent blog. I stumbledupon it 😉 I may return once again since I book marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide other people.

  14. dingdong online

    You made some good points there. I looked on the internet for more info about the issue and found most people will go along with your views on this web site.

  15. dingdong online

    Your style is so unique compared to other folks I have read stuff from. I appreciate you for posting when you have the opportunity, Guess I’ll just bookmark this site.

  16. dingdong 12d live

    May I simply just say what a relief to discover somebody that really understands what they are talking about on the internet. You actually know how to bring a problem to light and make it important. A lot more people should check this out and understand this side of the story. It’s surprising you’re not more popular since you most certainly possess the gift.

Comments are closed.