LinkBack URL
About LinkBacks
you could reference it with indirect instead
in this format
=IF(INDIRECT("sheet1!F5")=10,"true","false")
now if you say put 20 in F5 and 10 in F6 youd see false
but if you delete row 5 f5 would now be =10 and youd see true
you could reference it with indirect instead
in this format
=IF(INDIRECT("sheet1!F5")=10,"true","false")
now if you say put 20 in F5 and 10 in F6 youd see false
but if you delete row 5 f5 would now be =10 and youd see true
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks