[Solved] Nested IF() producing error 511

[hippyer]

Please can I get some help making this nested if statement work?

I'd like it to perform a different calculation if b15="BTC". I must have some semi colons or brackets out of place, but I can't figure it out for myself

Code: Select all

=IF(ISBLANK(F15);"";IF((B15)="BTC";IF((F15)="Long";((C15/E15)-H15-G15)-((C15/D15)-H15-G15);IF((F15)="Short";((C15/D15)-(C15/E15))/(C15/D15)-H15-G15)));IF((F15)="Long";((E15*C15)-H15)-((D15*C15)-H15-G15));IF((F15)="Short";(D15-E15)/D15-H15-G15;))

[FJCC]

I have not worked through all the logic of your calculations but perhaps you want this

Code: Select all

=IF(ISBLANK(F15);"";IF((B15)="BTC";IF((F15)="Long";((C15/E15)-H15-G15)-((C15/D15)-H15-G15);IF((F15)="Short";((C15/D15)-(C15/E15))/(C15/D15)-H15-G15));IF((F15)="Long";((E15*C15)-H15)-((D15*C15)-H15-G15);IF((F15)="Short";(D15-E15)/D15-H15-G15))))

or this somewhat simplifed version

Code: Select all

=IF(ISBLANK(F15);"";IF((B15)="BTC";IF((F15)="Long";((C15/E15)-H15-G15)-((C15/D15)-H15-G15);((C15/D15)-(C15/E15))/(C15/D15)-H15-G15);IF((F15)="Long";((E15*C15)-H15)-((D15*C15)-H15-G15);(D15-E15)/D15-H15-G15)))

[hippyer]

Thank you very much for your help. It seemed that indeed some of the logic of my calculations was incorrect, but your suggestions did parse without any error code and I have been able to make the necessary adjustments. Much appreciated.