Hi everyone,

I'm trying to use the IF function and I would like Excel to calculate the solution, if the logical test gives back TRUE. So I don't want to get back a set value but rather the solution of another function.



I tried
=IF((ROW(B11)-10)*$G$2<=A11<((ROW(B11)-10)+0.5)*$G$2,"=$G$4*SIN(2*PI()*$G$3*A11)",0)

(if the given value is between N*G2 and (N+0.5)*G2 (needed to improvise the N) it should use the given value to calculate the solution, else 0)

Is there any possibility to get back the solution of a function instead of a value?
Any help would be highly appreciated, I don"t know where to look anymore.

Thanks in advance!
Ohrringding

Sure, it is. I see two problems with your attempt (and I don't promise there aren't others):

1) Your condition; it's in the form lower <= A11 < upper. I'm guessing you mean that A must be between those two values, but Excel doesn't understand that syntax. Use this:(and I eliminated one unnecessary set of parens, but did not combine the terms; feel free to change it back if the parens make you more comfortable).

2) Your "True" value: eliminate the quote marks and the equal sign (which is needed only to start the whole formula, not for each part.

Combined, then, the whole thing should readCheck to be sure I didn't accidentally change something.