function in "value_if_true"

BobBridges · #2 09-02-2013, 07:51 PM

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:

Code:

AND((ROW(B11)-10)*$G$2<=A11,A11<(ROW(B11)-10+0.5)*$G$2)

(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 read

Code:

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

Check to be sure I didn't accidentally change something.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Office "version" function – what does it do?	eNGiNe	Office	0	06-10-2013 01:00 AM
Chart needs #N/A, SLOPE function needs "q"	ue418	Excel	0	10-16-2012 01:46 PM
How to "deactivate" the Excel's SAVE function	KIM SOLIS	Excel	1	11-05-2011 01:57 AM
Error: "The function you are attempting to run contains macros"	Fadi	Word	1	11-01-2011 05:25 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM