Need Support on Fixing formula to remove false when showing final output (Solved)

[surevyas]

Hi Team,
I have created the Nested formula, which states in case the Capitalization date is greater than month which is specified then result should show Either Blank or Zero.
Below is for your reference.
Request to please assist me in removing the out put False. I have attached the file for your reference. Please check Raw data sheet and formula from Column AR to BD

Your help will be much appreciated

=IF(AND(G4<=$AR$3,AQ4>=$AR$3),IF($L4="Tamil Nadu",'Reversal Ratio'!$C$4*'Raw Data'!AP4,IF($L4="Maharashtra",'Reversal Ratio'!$C$7*'Raw Data'!AP4,IF($L4="Gujarat",'Reversal Ratio'!$C$10*'Raw Data'!AP4,IF($L4="West Bengal",'Reversal Ratio'!$C$13*'Raw Data'!AP4,IF($L4="Delhi",'Reversal Ratio'!$C$16*'Raw Data'!AP4,IF($L4="Punjab",'Reversal Ratio'!$C$19*'Raw Data'!AP4,IF($L4="Karnataka",'Reversal Ratio'!$C$22*'Raw Data'!AP4,IF($L4="Telangana",'Reversal Ratio'!$C$25*'Raw Data'!AP4,IF($L4="Madhya Pradesh",'Reversal Ratio'!$C$28*'Raw Data'!AP4,IF($L4="Andhra Pradesh",'Reversal Ratio'!$C$31*'Raw Data'!AP4)))))))))))

 

[surevyas]

Can i request you to please share the file with updated formula, as i tried the above formula but its now working for me, also got the below error
Appreciated your assistance

 

[surevyas]

Thanks for the help, formula worked.
Appreciated your assistance