LinkBack URL
About LinkBacks
1. remove the if
2. if xxx is a text value, it should be between quotes like "xxx", however it could work if xxx = named range, referring to a cell value
=PRODUCT(((A15:A54=xxx)*(E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
1. remove the if
2. if xxx is a text value, it should be between quotes like "xxx", however it could work if xxx = named range, referring to a cell value
=PRODUCT(((A15:A54=xxx)*(E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks