Microsoft Office Forums - View Single Post - Combine Indirect and If formula?

Thread: Combine Indirect and If formula?

View Single Post

Old

04-15-2017, 10:24 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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.

Reply With Quote