Multiple IF Statement

[tlc53]

Hi there,

Can anyone see where I am going wrong please?

Basically, if N80 is >0 return "Enter Capital Gain XPA Code" if N80 is <0 return "Enter Capital Loss XPA Code"
Once the code is entered, I want the "Enter" to be removed from the description so,
If N80>0 and N84>0 return "Capital Gain XPA Code" if N80<0 and N84>0 return "Capital Loss XPA Code".

Here's a couple of my attempts so far, but they may just confuse you


=IF(N80>0,"Enter Capital Gain XPA Code:","Enter Capital Loss XPA Code:"),IF(AND(N80>0,N84>0,),"Capital Gain XPA Code:","Capital Loss XPA Code:")))

=IF(N80>0,"Enter Capital Gain XPA Code:","Enter Capital Loss XPA Code:"),IF(AND(N80>0,N84>0,),"Capital Gain XPA Code:",,)if(and(N80<0,N84<0),"Capital Loss XPA Code:",)))

Thank you!

 

[MAKHDOOMLIAQAT]

Re: Multiple IF Statement - Help

us if and at first then use if yoru formula will work

IF(AND(N80>0,N84>0,),"Capital Gain XPA Code:","Capital Loss XPA Code:")),=IF(N80>0,"Enter Capital Gain XPA Code:","Enter Capital Loss XPA Code:")

 

[jtakw]

Re: Multiple IF Statement - Help

Hi,

What if N80 is 0 (zero) ?

Assuming that doesn't happen, try this:

=IF(N84<0,"Enter ","")&IF(N80>0,"Capital Gain XPA Code",IF(N80<0,"Capital Loss XPA Code",""))

 

[tlc53]

Re: Multiple IF Statement - Help

Thanks again jtakw!
Slight amend, =IF(N84=0,"Enter ","")&IF(N80>0,"Capital Gain XPA Code",IF(N80<0,"Capital Loss XPA Code",""))
but it works perfectly now. Thank you!

 

[jtakw]

Re: Multiple IF Statement - Help

You're welcome, thanks for feedback.