I want to do the following: The answer for D13 must be D12-D11. However, if I don't put a value in D11, D13 must display nothing, even if there is a value in D12.

Is this possible?


you have to check if the cell is empty. For this you can use the function ISBLANK. So to get what you want you would enter the following in cell D13 =IF(ISBLANK(D11),"", D12-D11) which will show an empty string (so nothing) or the difference if there is something in D11. Bear in mind that this does not check against the type of values in D12 and D11 and might fail (if you put a string in any of those cells)

| improve this answer | |
  • Thx Zina. I must be doing something wrong. Keeps on showing error message when I OK formula. I am typing your excact formula in D13. Please bear in mind that I am not a pro in excel...... – L Strauss Dec 31 '15 at 13:29
  • Strange. I tested it before posting (excel 2013 on windows). Can you try to copy paste it from the answer? – Zina Dec 31 '15 at 13:31
  • Yep I did. Silly question...... I inserted the calculation in D13. Is this correct? – L Strauss Dec 31 '15 at 13:55
  • Can I not mail my speadsheet to you? – L Strauss Dec 31 '15 at 13:57
  • 1
    Try replacing the commas (,s) with semicolons (;s) — which one to use is a regional (i.e., language-based) setting.  But, if your system is set to English, this formula should work. – Scott Dec 31 '15 at 14:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.