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.
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 ✌️🙏
Very Simple and Informative Video ! Best wishes from Pakistan
Thank u. I searched for many ways and this is the best and easy way i foundout.
Welcome 👍
Thank you for making it simple!
Very helpful. Thank you very much.
Welcome
Excellent boss Thanks a lot
Welcome
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.
Well done.
Thank ya
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 ✌️🙏
This not nested if bb and remaining also getting answer is correct