trying to shorten an if statement - must be some other function

[pscseti]

I'm using =if(d3*e3/f3+g3<>0,d3*e3/f3+g3,0)

Isn't there something similar to iferror(x,0) - that simply returns x as long as x is not an error.

A number of times - I need to test if something meets some condition and if it does I just want that value returned and if not I want a zero - but it involves say if the calc meets the condition that I have to again say provide me with the calc.

Tx

 

[stumac]

It looks like you are

Testing if calculation = 0
if it is 0 then return 0
else return the value

So why test at all?

=D3*E3/F3+G3

Will give you the same value if it is 0 it will return 0 anyway?

 

[pscseti]

Probably I didn't explain well.

So I posted it again slightly differently.

Basically I often calculate the results of large equations. If the equation meets some condition - than I return the result + some other number. If it doesn't meet the condition than I return some other value

So I need to distinguish if the equation meets a condition and if it does return that equation without having to have that equation be the true result in an if statement.

Tx