Please help me with below formula:
=IF(G2="HOLD",F2+52,IF(G2="SUBMITTED",H2+45)).
I want formula to change only for Hold & to be Submitted condition. For rest conditions like Awaiting CTC,Cancelled,Clearing Conditions etc the formula should show the hold or submitted condition dates as per...
Please help me with the formulla for creating a range.
Example: I want to create a range if the # are between 1-5 as "01-05" and if the # are between 6-10 as "06-10" and so on till 100 & also want to add a condition if the #'s are greater than 20000 then it shows "Not Ordered" I have a formulla...
Hi Chandoo,
I have little bit of knowledge in Excel (say Excel Shortcuts, Formulas, etc). I was into MIS (Junior Executive)but due to some reason i had to leave the MIS profile & now i again want to do MIS related job. Please help me to know which of your course should i join?
I am having a day wise data sheets where in i want to know how many times a single customer has been called in a week or in a month (duplicates). I have the formula but if you can replace it with shorter one, b'coz if we go by this formula day wise it becomes large.
Formulla...