Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested functions

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Nested functions

Resolved · High Priority · Version 2007

Reply Thu 14 Oct 2010, 14:56Delegate Mark said...

Mark has attended:
Excel Intermediate course
Excel Advanced course

Nested functions

Would it be possible to check this formula?
Many thanks

=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,""))

Regards
Mark Graham

For upcoming training course dates see: Pricing & availability

Reply Fri 15 Oct 2010, 15:31Trainer Simon said...

RE: 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

Regards

Simon

Reply Fri 15 Oct 2010, 17:43Delegate Mark said...

RE: nested functions

nit really - its over 100 mb. I must be doing something really basic wrong...

Reply Mon 18 Oct 2010, 14:12Trainer Rodney said...

RE: nested functions

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

Reply Mon 18 Oct 2010, 16:21Delegate Mark said...

RE: nested functions

thanks for your help - it works fine now

Excel articles

· Conditional Formatting: A Useful Feature Of Excel
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· Reasons Why VBA for Excel Training Fails
· Correcting Numerical Glitches In Excel
· So Can You Really Sort On Colours In Excel 2007?

Please browse our web site to find out more about
excel consultant and other Microsoft training courses.

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips