if formula

[Likeexcel]

Hello:
Current formula<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
IF(OR(AU15={300010,300011}),0,IF(ISNA(MATCH(AT15,$AV$6,0)),"",SUM(AL15:AO15)))<o></o>
<o> </o>
Want to add this:<o></o>
If AE7-AC7 is less than 0 than IF(OR(AU15={300010,300011}),0,IF(ISNA(MATCH(AT15,$AV$6,0)),"",SUM(AL15:AO15)))<o></o>
But if AE7-AC7 is greater than 0 than IF(OR(AU15={300010,300011}),0,IF(ISNA(MATCH(AT15,$AV$6,0)),"",SUM(AL15:AM15)))<o></o>
Thank you for the help.<o></o>

 

[AlphaFrog]

Try something like this...

=IF(OR(AU15={300010,300011}),0,IF(ISNA(MATCH(AT15,$AV$6,0)),"",[COLOR="Red"]IF(AE7-AC7<0,SUM(AL15:AO15),SUM(AL15:AM15)[/COLOR])))

 

[Likeexcel]

Thank you, that works. However I'm getting a False error when there is no number. i've tried to put in IFERROR, but that didnt work.
any suggestions?

thank you again.

 

[AlphaFrog]

What's a False error?

"when there is no number"; No number where?

"i've tried to put in IFERROR, but that didn't work"; show what you tried.

 

[Likeexcel]

=iferror(IF(OR(AU15={300010,300011}),0,IF(ISNA(MATCH(AT15,$AV$6,0)),"",IF(AE7-AC7<0,SUM(AL15:AO15),SUM(AL15:AM15))),"0",(IF(OR(AU15={300010,300011}),0,IF(ISNA(MATCH(AT15,$AV$6,0)),"",IF(AE7-AC7<0,SUM(AL15:AO15),SUM(AL15:AM15)))))


thank you,

 

[AlphaFrog]

IFERROR function

Syntax
IFERROR(value, value_if_error)

=IFERROR(
IF(OR(AU15={300010,300011}),0,IF(ISNA(MATCH(AT15,$AV$6,0)),"",IF(AE7-AC7<0,SUM(AL15:AO15),SUM(AL15:AM15))))
,0)

 

[Likeexcel]

that works. thank you very much.