Related:
- Excel if cell contains word then assign value
- If cell contains multiple text then return value - Best answers
- If a cell contains a word then - Best answers
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel if cell contains date then return value ✓ - Office Software Forum
- Word free for u - Guide
- Count if cell contains number - Excel Forum
1 reply
OK, the syntax for IF is as follows:
[code]
=IF(LOGIC_TEST,TRUE,FALSE)
/code
So, an example of such would be:
In cell a3 set "=IF(a1="Widget","123","")"
So if you were to put Widget, in cell A1, Cell A3 would have an "123".
You can then NEST if statements, for the other values. Like so:
=IF(a1="Widget","123",if(a1="Sprocket","999",if(a1="Hinge","567","NONE")))
I hope you understand this example.
[code]
=IF(LOGIC_TEST,TRUE,FALSE)
/code
So, an example of such would be:
In cell a3 set "=IF(a1="Widget","123","")"
So if you were to put Widget, in cell A1, Cell A3 would have an "123".
You can then NEST if statements, for the other values. Like so:
=IF(a1="Widget","123",if(a1="Sprocket","999",if(a1="Hinge","567","NONE")))
I hope you understand this example.