Combine IF(OR and IF(AND - is this possible?

[katro]

Hello, I have an IF(AND and an IF(OR statement that each work individually, but I need to combine them into one function since I have multiple variables.
These are the functions that work separately:
=IF(AND(D13="SN",N13>M13),AB13,AC13)
=IF(OR(D13="GN",D13="GR"),AD13,AE13)

The N13>M13 only applies if D13="SN"; I also have additional formulas/calculations in AB13, AC13, AD13 and AE13 (I found it easier to put them in those cells rather than having a really complicated nested IF function, but it seems like I'm going back to the complicated route at this point). How do I make this into one function? I'm stumped! Thanks!!

[FDibbins]

Hi and welcome to the forum

maybe something like this>
=IF(AND(D13="SN",N13>M13),AB13,IF(OR(D13="GN",D13="GR"),AD13,AE13),AC13)
=

[katro]

Hi and welcome to the forum

maybe something like this>
=IF(AND(D13="SN",N13>M13),AB13,IF(OR(D13="GN",D13="GR"),AD13,AE13),AC13)
=

Thanks for the welcome and the reply!
Arrrrgggh! I put in the above into an empty cell and Excel is telling me (yet again) that I've "entered too many arguments for this function."

[AndyLitch]

Put the And boolean inside the OR brackets or vice versa
E.g

=IF(AND(D13="SN",N13>M13,OR(D13="GN",D13="GR")),AB13,AC13)

[FDibbins]

Andy, there are 4 possible answers AB13, AC13, AD13 and AE13

[abubaniyan]

=IF(AND(D13="SN",N13>M13),IF(AND(D13="SN",N13>M13),AB13,AC13),IF(OR(D13="GN",D13="GR"),AD13,AE13))

try this its done...!

enjoy....!

[katro]

=IF(AND(D13="SN",N13>M13),IF(AND(D13="SN",N13>M13),AB13,AC13),IF(OR(D13="GN",D13="GR"),AD13,AE13))

try this its done...!

enjoy....!

YESS!!!! This works! Thank you!! I will mark this thread as solved shortly, but can you explain why the red part of the function had to be entered twice? Just want to make sure I understand everything.
=IF(AND(D13="SN",N13>M13),IF(AND(D13="SN",N13>M13),AB13,AC13),IF(OR(D13="GN",D13="GR"),AD13,AE13))

Edited to add: Ahhhhh, I get it now. Never mind. I see why. =IF(AND(D13="SN",N13>M13),IF(AND(D13="SN",N13>M13),AB13,AC13) Thank you again!

[abubaniyan]

if has only two outcomes....
so for combining the same i have to create main condition....
once you fill the first...you will enter in the sub condition....


IF(AND(D13="SN",N13>M13),IF(AND(D13="SN",N13>M13),AB13,AC13),IF(OR(D13="GN",D13="GR"),AD13,AE13))