Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.