So, if it is "RSS", then add 50, otherwise just the year amount? If so, then try:
![]()
=IF(E2="RRS",50,0)+LOOKUP(I2,{0,6,11,20},{50,100,150,200})
So, if it is "RSS", then add 50, otherwise just the year amount? If so, then try:
![]()
=IF(E2="RRS",50,0)+LOOKUP(I2,{0,6,11,20},{50,100,150,200})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks