Help with nested IF(ISERROR Formula

[Kamitha]

Can anyone tell me where I'm going wrong on this formula? As the first IF statement, it calculates, but nesting causes the cell to think the formula is a giant string of text.

I'm trying to calculate different percentages based on options chosen on a list (C15 cell).

I thought I had it set up to if-iserror on statement 1, then move to statement two. Once I figure my nesting problem, I plan on nesting 4-5 statements.

=if(iserror(IF(C15="Campaign 1",(("PA Profit: "&M15*0.25)&(" KD Profit: "&M15*0.75))),"",(IF(C15="Campaign 2",(("PA Profit: "&M15*0.5)&(" KD Profit: "&M15*0.5)),""),"")"")

Thanks in advance!

 

[dreid1011]

Try this:

"PA Profit: "&M15*0.25&" KD Profit: "&M15*0.75

"PA Profit: "&M15*0.5&" KD Profit: "&M15*0.5

Too many parenthesis I think.


Annd, welcome to the board.

 

[svendiamond]

IFERROR is already pretty much an "if" formula. You don't need that first IF, then an ISERROR one.

Try:

=IFERROR(yourformula,"")

 

[Rick Rothstein]

Your IF function calls are not nested correctly. I am not completely sure if you need the ISERROR function call or if that is something you tried because the formula was not working correctly. Assuming an error check is not really needed, I think this should work...

=IF(C15="Campaign 1",("PA Profit: "&M15*0.25)&(" KD Profit: "&M15*0.75),IF(C15="Campaign 2",("PA Profit: "&M15*0.5)&(" KD Profit: "&M15*0.5),""))

If an error check turns out to be needed, then this should work...

=IFERROR(IF(C15="Campaign 1",("PA Profit: "&M15*0.25)&(" KD Profit: "&M15*0.75),IF(C15="Campaign 2",("PA Profit: "&M15*0.5)&(" KD Profit: "&M15*0.5),"")),"")

 

[Kamitha]

Thanks everyone!

Does anyone know why the cell would be treating these formulas as text? I can't figure out why it would do that once nesting is entered into the formula. I copy and pasted the two formulas above, and it treats both as text.

 

[svendiamond]

Format your cells as "General" rather than "Text"

 

[Rick Rothstein]

Does anyone know why the cell would be treating these formulas as text? I can't figure out why it would do that once nesting is entered into the formula. I copy and pasted the two formulas above, and it treats both as text.

The formulas I posted go into cells as formulas for me. If, however, your cell is formatted as Text, then they will go into that cell as text instead of a formula, so make sure your cells are formatted as General before entering the formula into the cell.