parenthesis correction I cant figure out. Pls help!

[DaveG999]

I want my formula to contains two conditions. The first is =IF(B12>943000,0,(B12-B14)) .This works fine.
How do i add a second condition, which is if B12<893,000,0 ( a zero return if the number is less than 893K)

=IF(B12>943000,0,(B12-B14),IF(B12<893000,0)) does not seem to work

Many thanks!!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(or(B12>943000,b12<893000),0,B12-B14)

 

[DaveG999]

=IF(or(B12>943000,b12<893000),0,B12-B14)

GREAT!!! Thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.