Ask Your Question
0

IF THEN ELSE NESTED returning wrong or improper values [closed]

asked 2013-10-03 21:13:18 +0200

Xlaits gravatar image

updated 2015-10-26 22:05:41 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 22:05:59.069810

1 Answer

Sort by » oldest newest most voted
0

answered 2013-10-03 22:17:40 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Comments

Cleared Direct formating seemed to fix it.

Xlaits gravatar imageXlaits ( 2013-10-06 11:42:24 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-10-03 21:13:18 +0200

Seen: 2,674 times

Last updated: Oct 03 '13