hardeep.kanwar
New Member
Hi!!
I am using IF formula using Drop Down.
Drop Down List
1: SGST/CGST
2: IGST
Other Condition in J3,K3,L3 i.e. SGST@9% CGST@9% IGST@18% RespectivelyNow i am using below Formula for IGST@18% its working and calculate the Value fine
Formula is for IGST@18%= =IF($R5&"@18%"=$L$3,$H5*18%,"0")
But i have tried and its not working in other conditions i.e SGST@18% and CGST@18%
Below is the Formula for both Conditions :=IF($R5&"@9%"=$J$3&"/"&$K$3,$H5*9%,"0")
Any idea where i am lacking
Thanks in advance
I am using IF formula using Drop Down.
Drop Down List
1: SGST/CGST
2: IGST
Other Condition in J3,K3,L3 i.e. SGST@9% CGST@9% IGST@18% RespectivelyNow i am using below Formula for IGST@18% its working and calculate the Value fine
Formula is for IGST@18%= =IF($R5&"@18%"=$L$3,$H5*18%,"0")
But i have tried and its not working in other conditions i.e SGST@18% and CGST@18%
Below is the Formula for both Conditions :=IF($R5&"@9%"=$J$3&"/"&$K$3,$H5*9%,"0")
Any idea where i am lacking
Thanks in advance