Combine Indirect and If formula?

		Microsoft Office Forums > Microsoft Excel > Excel
Combine Indirect and If formula?

FAQ

Thread Tools

Display Modes

04-15-2017, 10:24 AM

xor

Windows 10 Combine Indirect and If formula?

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

If I understand what you want:

=IF(INDIRECT("P7")-INDIRECT("P11")<1,"",INDIRECT("P7")-INDIRECT("P11")) or better

=if(INDEX(P:P,7)-INDEX(P:P,11)<1;"",INDEX(P:P,7)-INDEX(P:P,11)

Better because INDEX contrary to INDIRECT is non-volatile. Volatile functions may make Excel slow if you work with large models.

Last edited by xor; 04-15-2017 at 11:40 PM.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Indirect with hlookup	jamesjts	Excel	3	01-05-2016 09:13 AM
Indirect AND OR Formula Help	del_piero_3	Excel	3	09-18-2015 02:58 PM
Indirect Reference?	tinfanide	Excel	2	08-28-2015 05:11 PM
Indirect Formula with dynamic rows	bluionz	Excel	1	03-13-2014 11:00 AM
Indirect	zleyphox	Excel	1	02-11-2010 09:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:54 PM.