# Complicated IF Formula under multi conditions

October 12, 2017 at 02:15:02
Specs: Windows 8
 Sorry i am really a noob in excel , now i am in situation in my work and must achieve spread sheets with many complicated formulas that i never needed to use before , i keep searching in google but that does not help 100%i hope i will be able to easily explain my need , these will be 2 casesif i run a warehouse and there is a cargo i need to calculate its storage period in this warehouseCell B7 : cargo stored on 01/08/2017Cell B8 : cargo released on 05/08/2017 In Cell B15 : it reads exactly contents of B7in Cell C15 , i want to do the following :1- if B8 date >= 1st of October 2017 , then insert 30 September 20172- if B8< 1st of October 2017 , then insert contents of B8how to do that ?Also another case---------------------------Cell B7 : cargo stored on 01/08/2017Cell B8 : cargo released on 05/08/2017 I want to apply following three conditions in Cell A15 :1- if B7>= 1st October 2017 , insert "-"2- if B7< 1st October 2017 , insert "30/09/2017"3- if B8<1st October 2017, insert (B8)how to do that ?sorry for disturbance and thanks for all appreciated assistance .

See More: Complicated IF Formula under multi conditions

#1
October 12, 2017 at 03:56:40
 Before we offer any solutions, let's make sure we have your requirements correct.First, you told us that B15=B7, but then you never mentioned B15 again. Why did you tell us that B15=B7?Second, for cell A15, you are basing the result on the contents of 2 different cells: B7 and B8. What happens if both B7 and B8 are < 1st October 2017? If that is a possibility, then your requirements can not be met.Please clarify.