Nested if (again .. Sorry)

[DoosanRuss]

Good Afternoon Ladies and Gents
(Excel 2003 (XP) user)

trying to nest up a few IF Formulas into one equation

IF(AND(B56=FALSE,B57=FALSE,B58=FALSE), “TICK PRICING OPTIONS”, “ ”)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
IF(AND(B56=TRUE,B57=FALSE,B58=FALSE), “OPT1”, “ ”)<o></o>
IF(AND(B56=FALSE,B57=TRUE,B58=FALSE), “OPT2”, “ ”)<o></o>
IF(AND(B56=FALSE,B57=FALSE,B58=TRUE), “OPT3”, “ ”)<o></o>
IF(AND(B56=FALSE,B57=TRUE,B58=TRUE), “OPT2”, “ ”)<o></o>
IF(AND(B56=TRUE,B57=TRUE,B58=TRUE), “OPT1”, “ ”) <o></o>

basically i have 3 check boxes in B56, B57 & B58

based on the True or False answers of the Checkboxes i want to select different Pricing Options (from different sheets, OPT1,2 & 3)

As Always any help gratefully received

Best Regards

Russ

 

[Weaver]

Try this:

=IF(B56,"OPT1",IF(B57,"OPT2",IF(B58,"OPT3","TICK PRICING OPTIONS")))

 

[ukmikeb]

Hi

This solution would give you the option of expanding the selection if needed -

=CHOOSE(1+SUM(--($B$56),--($B$57)*2,--($B$58)*4),"TICK OPTION","OPT1","OPT2","","OPT3","","OPT2","OPT1")

hth

Mike

 

[DoosanRuss]

Thanks guys

i've tried to extract what you've given me to use on other cells, but i think i'm to thick and i don't have a lot of time to complete this darn spreadsheet.

I've re-posted another query similar to the first problem.

utilizing the IF(AND(NOT set of arguments.

Thanks all the same Russ

 

[Weaver]

Thanks guys

i've tried to extract what you've given me to use on other cells, but i think i'm to thick and i don't have a lot of time to complete this darn spreadsheet.

I've re-posted another query similar to the first problem.

utilizing the IF(AND(NOT set of arguments.

Thanks all the same Russ

Ignoring the other query for a moment, are you saying you tried this in a cell and then tried to copy it into others, without success?
When the formula is in other cells, are there tick boxes on each row or should the formula refer to the same set of cells?