**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I need a formula that sums two separate column and two separate cells and only shows an answer if the resulting number is between 0 and 365 ie L2-G2 but only show the answer if it is between 0 and 365.
Thanks

Solved by V. E. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
14/08/2018 - 05:17

HI,

Excelchat Expert
14/08/2018 - 05:18

It's pleasure to help you today.

User
14/08/2018 - 05:18

Thank you

Excelchat Expert
14/08/2018 - 05:18

You wan to add sum of 2 columns and check the condition? Please share the sample info.

User
14/08/2018 - 05:22

attached is my spreadsheet

[Uploaded an Excel file]

Excelchat Expert
14/08/2018 - 05:23

I am checking the file.

Excelchat Expert
14/08/2018 - 05:25

I have opened the file.

User
14/08/2018 - 05:25

I have tried several different formulas to try and get rid of negative numbers and numbers over 365

User
14/08/2018 - 05:26

What I would like is to be able to show all negatives and all numbers over 365 as blank cells

Excelchat Expert
14/08/2018 - 05:26

Sure Can you please provide me an example to get some more idea.

User
14/08/2018 - 05:28

please note column Q, I have been able to rid myself of numbers over 365 but am still receiving negative numbers.

Excelchat Expert
14/08/2018 - 05:29

=IF(P2-L2>=0 & P2-L2 <=365,P2-L2,"")

Excelchat Expert
14/08/2018 - 05:29

Here is the formula.

User
14/08/2018 - 05:30

Thank you Very much

Excelchat Expert
14/08/2018 - 05:30

L2 is blank actually.

Excelchat Expert
14/08/2018 - 05:30

That is the existing formula.

User
14/08/2018 - 05:30

yes, there will be blank cells and that is what is causing part of the issue, but those cells must be blank until the work is actually done.

Excelchat Expert
14/08/2018 - 05:31

Ok. So, the end result also shall be blank when either is blank?

User
14/08/2018 - 05:32

end result should be blank if result is <0 or >365

Excelchat Expert
14/08/2018 - 05:32

Ok.

Excelchat Expert
14/08/2018 - 05:32

Ok. I am working on the formiula.

Excelchat Expert
14/08/2018 - 05:35

=IF(P2-L2<0,"",IF(P2-L2>365,"",P2-L2))

Excelchat Expert
14/08/2018 - 05:35

Please check the formula.

Excelchat Expert
14/08/2018 - 05:41

HI, Hope it is reviewed.

User
14/08/2018 - 05:41

Still showing as not valid

Excelchat Expert
14/08/2018 - 05:42

I am getting as blank.

Excelchat Expert
14/08/2018 - 05:42

I will send you the file.

Excelchat Expert
14/08/2018 - 05:43

.

[Uploaded an Excel file]

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*