How to add a value to a cell if the other cell has text
Closed
jormis
Posts
2
Registration date
Wednesday 6 November 2013
Status
Member
Last seen
7 November 2013
-
6 Nov 2013 à 11:25
Blocked Profile - 7 Nov 2013 à 14:27
Blocked Profile - 7 Nov 2013 à 14:27
Related:
- How to add a value to a cell if the other cell has text
- How to add at the rate in laptop - Guide
- How to add a checkmark in word - Guide
- How to delete a cell in word - Guide
- How to add authorized user t mobile - Guide
- How to add keywords to youtube channel - Guide
5 responses
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
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
jormis
Posts
2
Registration date
Wednesday 6 November 2013
Status
Member
Last seen
7 November 2013
7 Nov 2013 à 02:37
7 Nov 2013 à 02:37
i am trying with copy paste the formula in my excel.
i am replacing sometext with my word but it is not working.
i am replacing sometext with my word but it is not working.
