Menu
I have a cell which contains any 4 letters, example akei, skiw. How do I ask
"if the 3rd letter is an i then equals True"
I was thinking something like
"=if(a1="??i?", True, False)"
But that dosen't Work
524
Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")
To add an ordinal suffix to a number (i.e. 1st, 2nd, 3rd, etc.) you can use a formula based on the CHOOSE function to assign the suffix. Ordinal numbers represent position or rank in a sequential order. They are normally written using a number + letter suffix: 1st, 2nd, 3rd, etc.
=MID(A1,3,1) = "i"
Should work, you don't need to use IF, the evaluation using the equals will return either TRUE or FALSE
58
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
