Thank you for making it simple!

Thank u. I searched for many ways and this is the best and easy way i foundout.

Thank you much for the video. I would require some advice from you. How do I format the layout if I need to use text and multiplication . Eg Lets say Copper carries 1 Amp of current, Tin carries 0.5 Amp and Aluminium carries 0.1 A current, So how do I make up a statement in excel that if I use the text "Copper" on the excel cell it automatically multiplies the "1 Amp with a constant number of 0.85" and If I use the text "Tin" then excel multiplies "the 0.5 A with 0.45 " I hope my question makes sense.

Very helpful. Thank you very much.

Well done.

Excellent boss Thanks a lot

Hi! Im struggling with the following formula I would like to use. Column B has got text. With discriptions and names etc. Column B is in a table called (discription) For this column I use the =IF(COUNTIF(discription,''*abc*'',''A'',"") But I want to add another if to this formula for example =IF(COUNTIF(discription,''*123*'',''B'',"") And 3 to for more IF('s) Im stuck, hope someone could give some advice ✌️🙏

Thank ya

This not nested if bb and remaining also getting answer is correct