Dont Sum if Zero found

[The Animal]

Hi
Just a quick question
I have a simpe formula =GT274+GY272 but i want to return a "0" if GY272 =0, GT274 will have a value which will be either positive of negative.

Thanks Stephen

 

[joeu2004]

=if(gy272=0, 0, gy272+gt274)

 

[The Animal]

Great thanks

 

[Peter_SSs]

@joeu2004

work around forum anomaly (didn't work)

If you are referring to the conversion of a formula to lower case, simply put some other text (must include at least one letter I think) in your post as well as the formula. Example below:

 

[Peter_SSs]

Try
=IF(GY272=0, 0, GY272+GT274)