Nesting if formula

Resolved · High Priority · Version 2003

Tue 12 Jun 2012, 16:03 Delegate Ajit said...

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.

Wed 13 Jun 2012, 15:08 Trainer Simon said...

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

Wed 13 Jun 2012, 15:38 Delegate Ajit said...

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.

Wed 13 Jun 2012, 16:09 Trainer Simon said...

RE: Nesting if formula

Hi Ajit,

Thank you for your response.

My email address is:

sk@stl-training.co.uk

Regards

Simon

Wed 13 Jun 2012, 16:13 Delegate Ajit said...

RE: Nesting if formula

Thanks Simon

I have emailed you the spreadsheet.

Ajit

Thu 14 Jun 2012, 09:07 Trainer Simon said...

RE: Nesting if formula

Hi Ajit,

Thank you.

Regards

Simon

Thu 14 Jun 2012, 14:14 Trainer Simon said...

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