Joining 2 formulas into 1 condition

[elynoy]

Hello.

How can I join 2 formulas into 1?

I have this:

=SE(AZ8=0;0;AZ8-$AX$6)

And I want to create a formula with that same exact formula but with a condition on it to either use one cell value or another.

I have this and it works but I want it to show nothing or 0.

=SE(BD8="sim";AZ8-$AY$6;AZ8-$AX$6))

the problem with this one is that it shows the negative value of the calculations and I only want it to show it when there are values in the respective cell with is AZ8.

Best regards,
eLy

 

[Fluff]

How about
=SE(AZ8=0;0;SE(BD8="sim";AZ8-$AY$6;AZ8-$AX$6)))

 

[elynoy]

Thank you. Works like a charm!

eLy

 

[Fluff]

You're welcome & thanks for the feedback