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.
