How to add a value to a cell if the other cell has text

[Closed]
Report
Posts
2
Registration date
Wednesday November 6, 2013
Status
Member
Last seen
November 7, 2013
-
 Blocked Profile -
Hi,

i am not able to find how to do the following formula in excel.

what is the exact formula for: "if the value of the cell A2 is text then the value in B2 is 4".

how to do this? text in the cell could be "jave".

thank you

5 replies


Good Morning,

the logic statement for EXCEL is in this format:
=if(logic test, true, false)

so your formula would be like:
=if(A2="sometext",4,0)

The above would be in cell B2. Be certain to replace "sometext" with your text. I understand it will be jave.

You can nest if statements, also.

Have fun!

//ark
-Contributor
Posts
2
Registration date
Wednesday November 6, 2013
Status
Member
Last seen
November 7, 2013

i am trying with copy paste the formula in my excel.

i am replacing sometext with my word but it is not working.

jormis,

What cell are you pasting it in? I just cut and pasted it into my sheet, and it worked. :(
If the text is in A2 i am pasting in B2.

Ok, good. So try to paste it into the formula bar, and not the cell directly. :)