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.