IF THEN ELSE NESTED returning wrong or improper values

[Xlaits]

Using a Rather complex IF statement, I’m trying to make a system by having it check a dropdown’s value.

Here’s the statement.

=IF(A2=“Lurker”,B2+12+4,IF(A2=“Solder”,B2+12+2,IF(A2=“Skirmisher”,B2+12+2,B2+12)))

It’s supposed to return a number. It’s returning “TRUE” or “FALSE,” Not the value intended.

[mariosv]

I think it is only a format issue, any value different from zero is TRUE, try changing the cell format. Maybe B2 has a boolean value format.

[Xlaits]

Cleared Direct formating seemed to fix it.