simplfying an IF statement

[Gunblade]

Hi all,

Placed in VBA as I'm coding it in VBA, though technically this question could probably be applicable to any if statement in any language.

I currently have an if statement that goes like:

Please Login or Register  to view this content.

I've always wondered if there's a way to not have the statement have to technically evaluate twice, I've not actually seen anything around google (or don't know what to search for).
If the value is not 0, use that already calculated value but if it's zero print "zero".

Essentially I'm looking for

Please Login or Register  to view this content.

It gets pretty bad if for example I have nested if statements or a row of if statements all doing the same thing and the code becomes bloated with what appears to be redundancy.

Thanks.

[FDibbins]

Sometimes there is no other way around it. Other times you could use a helper column to run the "long formula", then test the helper...
=if(helper<>0,helper,0)

essentially the same thing, but the reference would be far shorter

[AlphaFrog]

Calculate the result of the long evaluation formula and test the result for zero.

Please Login or Register  to view this content.

[Gunblade]

Much appreciated.

I'll mark this is a solved.

[FDibbins]

Happy to help and thanks for the feedback