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