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

Closed
jormis Posts 2 Registration date Wednesday November 6, 2013 Status Member Last seen November 7, 2013 - Nov 6, 2013 at 11:25 AM
 Blocked Profile - Nov 7, 2013 at 02:27 PM
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 responses

Blocked Profile
Nov 6, 2013 at 11:51 AM
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
0
jormis Posts 2 Registration date Wednesday November 6, 2013 Status Member Last seen November 7, 2013
Nov 7, 2013 at 02:37 AM
i am trying with copy paste the formula in my excel.

i am replacing sometext with my word but it is not working.
0
Blocked Profile
Nov 7, 2013 at 02:05 PM
jormis,

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

Didn't find the answer you are looking for?

Ask a question
Blocked Profile
Nov 7, 2013 at 02:27 PM
Ok, good. So try to paste it into the formula bar, and not the cell directly. :)
0