Nested functions

Hi Mark,

Thank you for your question and welcome to the forum.

Is it possible to send me a copy of the workbook to put the formula in context?

If so, please send it to sk@stl-training.co.uk

Regards

Simon

Hello Mark,

Hope you enjoyed your Microsoft Excel course with Best STL.

Thank you for your question regarding nested functions. There are only two adjustments you need to make to your formula. Add a bracket just after $D$4 which will end the AND function. Then remove the last bracket... remember, one IF usually one end bracket. See the following then copy and paste.

=IF(AND(ABS(('Input data'!ATI13-'Input data'!$BIH12)/'Input data'!$BIH12)<$B$4,ABS(('Input data'!ATI13-'Input data'!$BIH12)/'Input data'!$BIH12)>$D$4),('Input data'!ATI13-'Input data'!$BIH12)/'Input data'!$BIH12,"")

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer