If Then FormulaClosed

Question

Hello, I am trying to build an If Then formula. I am trying to reference a cell with a  specific text in one cell like A2=Light and only if Lights is in the cell it will multiply the cell next to it B2=10 with 3 in cell C2.
Please help. I found a formula from another question which made me think of this question. +=IF("","",(1=C3)). 
Thank you very much for helping me with this. I haven't had much luck with getting it to work.


Configuration: Windows 7 / Chrome 49.0.2623.110

vcoolio · Answer

Hello Glyde,

You could try the following in C2, dragged down as far as you need:-

=IF(ISTEXT(A2),B2*3,"")

This will allow you to place any text value (and only text) in Column A and hence the value in B2 will be multiplied by 3 with the result shown in C3. 

It also assumes that the Column B values will always be multiplied by 3.

I hope that this helps.

Cheerio,
vcoolio.

vcoolio · Answer

Hello Glyde,

I'm not sure what you mean by multiple texts, but the formula allows you to use any form of text (in this case in any cell in Column A as long as you have dragged the formula down in Column C).

Cheerio,
vcoolio.

If Then Formula

2 responses

Similar discussions

Subscribe To Our Newsletter!