Perhaps:
=6%*IF(N(E3)<50,0,IF(N(E3)<1000,N(H6),949.99)
(note I've assumed >=1000 warrants use of 949.99 - the tiers outlined do not overlap otherwise)
Perhaps:
=6%*IF(N(E3)<50,0,IF(N(E3)<1000,N(H6),949.99)
(note I've assumed >=1000 warrants use of 949.99 - the tiers outlined do not overlap otherwise)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks