Wrong Result--Help!

[Guest]

I'm using the formula below, which works with the
exception if it is false, I get "false" as a result and I
want 0 as a result, can you help me?

=IF(AND(OR
(I7="(00140)",I7="(35200)",I7="(35300)"),K22>J22),ROUND((-
25%*(K22-J22)),0))

 

[Andy B]

Hi

Try this:
=IF(AND(OR

(I7="(00140)",I7="(35200)",I7="(35300)"),K22>J22),ROUND((-
25%*(K22-J22)),0),0)

In other words, just insert a ,0 before the last bracket

 

[Domenic]

Hi,

Just add a comma and zero before the last bracket, like this,

=IF(AND(OR(I7="(00140)",I7="(35200)",I7="(35300)"),K22>J22),ROUND((-25%*(
K22-J22)),0),0)

Hope this helps!

 

[Guest]

Thank you Mr. Andy, I nearly pulled all my hair out. Have
a wonderful day.

 

[Andy B]

Cheers and thank for the feedback!

--
Andy.

Thank you Mr. Andy, I nearly pulled all my hair out. Have
a wonderful day.