I am attempting to use nested ifs without success. Hows the situation:
Three cells (a1,a2,a3) will contain the values of true/false. Two will be fasle and 1 true.
I have coded the following statement:
=if(a1=true,"Team A"); if(a2=true, "Team B"); "Tie")
I get a 508 err.
What is my coding error?
Thanks.
Something like:
=IF(A1=TRUE,"Team A",IF(A2=TRUE,"Team B","Tie"))
Regards
What is "508 err" ?
Haven't seen that yet in XL ( maybe in VBA?)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks