Is there a function to display the current filename or file TYPE ? (Without VBA)...

[SOLVED] - Solved by SHG ... THANKS !



Hey again, :-)

Is there a function or formula that could display the filename (or better yet, the file TYPE) in a cell ?

What I want to do is this :

Example ONLY:
(IF "**save.xlsx*" isin $filename then (1+2), else (3x4) )

Is this possible ?
Thanks again !





[SOLVED] - Solved by SHG ... THANKS !

=IF(ISNUMBER(SEARCH("save.xlsx", CELL("filename"))), 1+2, 3*4)

Originally Posted by shg

=IF(ISNUMBER(SEARCH("save.xlsx", CELL("filename"))), 1+2, 3*4)

"You R - A - Jean Yes ...."

Thank u for your time !



Thanks Again !

[Resolved]






[SOLVED] - Solved by SHG ... THANKS !