Excel Mid and If function

[Dilshanth10]

Picture1.png
Picture2.png

i made mid column and typed mid formula to add values in mid column.
but when i made if formula in another column with this mid column, it did not appear true value..
how to solve this problem..
if this is not the right way, then tell me which is the best way to make this concept correct..

[Moo the Dog]

In the future, please upload a copy of your workbook instead of images.

MID returns a text string, not numeric values... and you don't need the MID column at all, just incorporate it into your formula.

Try this:
=IF(MID(A2,3,3)*1>366,"Female","Male")

- Moo

[Dilshanth10]

thanks... and i'll put that in my mind

[Moo the Dog]

You're welcome. Glad to help

- Moo