LinkBack URL
About LinkBacks
hi i have 2 criteria product if fumction. İts working, =PRODUCT(IF((E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
when i add more 1 criteria function is not working =PRODUCT(IF((A15:A54=xxx)*(E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
hi i have 2 criteria product if fumction. İts working, =PRODUCT(IF((E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
when i add more 1 criteria function is not working =PRODUCT(IF((A15:A54=xxx)*(E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
Try
=PRODUCT(IF((A15:A54="xxx")*(E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks