Ajit has attended:
Excel Advanced course
Nesting if formula
I have used Find and Mid formulas to pick out two different charters and had to put separate formuals in 4 columns. Also there are blank line. Is there a way where I can nest all these 4 formulas in one cell and also a formula within it for blank lines.
RE: Nesting if formula
Hi Ajit,
Thank you for your question.
Is it possible to send me the four formulas and a bit more background on the result you seek.
Regards
Simon
RE: Nesting if formula
Hi Simon, I would like to send the speadsheet but I don't seem to have the option here to upload it. Can you let me know how I will be able to send you the spreadsheet with the formulas on.
RE: Nesting if formula
Hi Ajit,
Thank you for your response.
My email address is:
sk@stl-training.co.uk
Regards
Simon
RE: Nesting if formula
Thanks Simon
I have emailed you the spreadsheet.
Ajit
RE: Nesting if formula
Hi Ajit,
Thank you.
Regards
Simon
RE: Nesting if formula
Hi Ajit,
This is the closest I can get with the time I have allocated to this forum post. I have found it difficult to nest all 4.
Please find the workbook attached.
I hope this has helped you.
Regards
Simon
Nesting Formula query-14June12.xls
