[Solved] Excel Formula

[hea_ven]

what is the formula to use so I can get the amount in column C and D

 

[Mashhura Jahan]

what is the formula to use so I can get the amount in column C and D

Hello hea_ven,

Thank you for your question. I have seen the file you attached and used two formulas to calculate the Amount Covered and the Amount not Covered.

• You can write the following formula in Cell C2 to calculate the Amount Covered and then drag the Fill Handle down to copy the formula in the other cells.

=IF(A2>=B2,B2,IF(AND(A2<0,B2>0),A2,IF(AND(A2<0,B2<=0),B2,A2)))

• Then, I used the following formula in Cell D2 to calculate the Amount not Covered and then dragged the Fill Handle down to copy the formula in the other cells.

=A2-C2



I hope this will solve your problem. I have also attached the Excel file here for your convenience. Please let us know if you face any problems.

Regards
Mashhura Jahan
ExcelDemy