Is there a shorter way to write this function?

[excelos]

Hello,

I want make a calculation and if negative to make it zero, while if possitive to leave it as is.

I write it as:

[]=IF(($D$123-D30*$D$10/$D$21)>0,$D$123-D30*$D$10/$D$21,0)[]


Is there a way to make it shorter without having to repeat it twice in the formula because it gets very long?

Thanks!

 

[gaz_chops]

Try

=MAX(0,$D$123-D30*$D$10/$D$21)

 

[Finalfight40]

Hello,

I want make a calculation and if negative to make it zero, while if possitive to leave it as is.

I write it as:

[]=IF(($D$123-D30*$D$10/$D$21)>0,$D$123-D30*$D$10/$D$21,0)[]


Is there a way to make it shorter without having to repeat it twice in the formula because it gets very long?

Thanks!

How about:

=max($D$123-D30*$D$10/$D$21, 0)

 

[excelos]

How about:

=max($D$123-D30*$D$10/$D$21, 0)

That's great, it will save me a lot of work.
But is there a RegEx to make the change in every cell automatically?