Good afternoon everyone

I have the following 2 formula's that are working perfectly for me

=(SUMPRODUCT((K99<70%)*(B118=1),K78*'Base Data'!$I$31))
=(SUMPRODUCT((K99100%)*(B118=1),K78*'Base Data'!$G$31))

I need one last formula that allows me to say if K9970% but less than 100%

Can anybody offer any help, I can't seem to enter it without getting an error