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
Blocked Profile - Nov 7, 2013 at 02:27 PM
Related:
- How to add a value to a cell if the other cell has text
- Conditional formatting if cell contains text - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Pdf and xps add in 2007 - Download - Other
- How to add @ in laptop - Guide
- How to add a tick in word - 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 November 6, 2013
Status
Member
Last seen
November 7, 2013
Nov 7, 2013 at 02:37 AM
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.
i am replacing sometext with my word but it is not working.
Didn't find the answer you are looking for?
Ask a question
