View Single Post
 
Old 10-07-2017, 02:35 AM
Liquid77 Liquid77 is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2017
Posts: 3
Liquid77 is on a distinguished road
Default INDIRECT Function not working

Hi there,

should be so easy, but I can't get it working:

I'm using this Formula to get a "1" Value when FIND a "-" symbol in a Cell two columns to the right.
Code:
=FIND("-",(INDIRECT("RC2",FALSE)))
Can anyone tell me, why it's not working. It always shows #VALUE!

Thank you
Reply With Quote