Formula to show me if document has been saved as name in a cell

[tonywatsonhelp]

Hi Everyone,
I need a formula to do the following

If AB25 = the name of this document, then "Saved" else "Not saved"

So what i'm trying too do is see if I have saved the document
AB25 is the cell I'll try the name of the document into so it might say "Tonys Test Doc"
so i want the formula to check if thats the documents name.

please help if you can

Thanks

Tony

 

[Dave Patton]

Edit the Cell data and location for your information; just change the B3 to your reference AB25.
If you have the new LET function use it instead of V() in the second alternative; if you do not have Let or the UDF V() you can ignore the second alternative.

T202011a.xlsm
	A	B	C
1
2	File Name	Match
3		T202011a	Saved
4	T202011a	T202011a	Saved
5	T202011a	T202011a	Saved
6
1d

Cell Formulas
Range	Formula
A4	A4	=REPLACE(LEFT(CELL("filename",A1),FIND(".",CELL("filename",A1))-1),1,FIND("[",CELL("filename",A1)),"")
A5	A5	=REPLACE(LEFT(V(CELL("filename",A1)),FIND(".",V())-1),1,FIND("[",V()),"")
C3	C3	=IF(REPLACE(LEFT(CELL("filename",A1),FIND(".",CELL("filename",A1))-1),1,FIND("[",CELL("filename",A1)),"")=B3, "Saved","Not Saved")
C4:C5	C4	=IF(A4=B4, "Saved","Not Saved")

 

[tonywatsonhelp]

Thanks Dave,
this all i needed i;ve got it now

 

[Dave Patton]

Thanks for the feedback.