=SUMPRODUCT((HPACB=1)*(HPNINS<24)*(RATE={4.50055})*BAL)
In above formula I am trying to give the rate range between 4.500 to 5.500 but it giving me zero outstanding where there is outstanding.I believe there is problem In range.Could any please help.Regards,
In above formula I am trying to give the rate range between 4.500 to 5.500 but it giving me zero outstanding where there is outstanding.I believe there is problem In range.Could any please help.Regards,