• 100% Satisfaction Guarantee

Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32057
Experience:  Over 15 years of consulting to the IT industry
32989067
Richard is online now

# I am probably after something really simple but just

### Resolved Question:

Hi
I am probably after something really simple but just cant work it out.
What I am after is to subtract a number from a number in a cell for example below:
=D3-300
However when there is nothing in cell 'D3' I would like the cell containing the above formula to be blank
Is this possible?
Thanks
James
Submitted: 1 year ago.
Category: Computer
Expert:  Richard replied 1 year ago.
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
You can say
=if(D3=0,0,D3)
But you cannot remove the formula itself, as a formula cant remove itself because it needs to be there to do the actual formula.
If you would like any additional information or assistance, please do not hesitate to let me know.
And if you can take a second to rate my service, that would be greatly appreciated.
Thank you
Customer: replied 1 year ago.

Hi

Thanks for the fast response but when I enter this it just copies whats in cell D3.

If I type in:

=if(D3=0,0,D3)-300

I can still see it saying -300 when the cell is blank?

I don't want to see -300 when D3 is blank

Thanks

James

Expert:  Richard replied 1 year ago.
ok, then use
=if(D3="","",D3-300)
Use that formula
Let me know if you have any difficulties please
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32057
Experience: Over 15 years of consulting to the IT industry

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• ### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >

### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

### James K.

#### Satisfied Customers:

93
Technical Director of IT Company

### Jon-Tech

#### Satisfied Customers:

61
20 yrs: Computers, Networking

### MikeW

#### Satisfied Customers:

53
32+ years Computer and Networking Experience

### jamieratliff

#### Satisfied Customers:

21
Jamie has worked in the Information Technology field for over a decade.

### TheDoctor

#### Satisfied Customers:

16
Experienced Software Engineer

### Bill Fisher

#### Satisfied Customers:

1
Computer system design, networks, integration, general support.