BMW 3-Series (E90 E92) Forum - View Single Post

jpsum · 09-29-2011, 09:08 AM

You shouldn't get that error. It's a IF/ELSE function. If A4 does not = Add, then it subtracts.

Or you can do this if you want to be a little more proper: =IF(A4="Add",B1+B4, IF(A4="Subtract",B1-B4))

09-29-2011, 09:08 AM	#7
jpsum Major 274 Rep 1,088 Posts Drives: 2010 TSX Join Date: Dec 2008 Location: New Haven area iTrader: (4)	You shouldn't get that error. It's a IF/ELSE function. If A4 does not = Add, then it subtracts. Or you can do this if you want to be a little more proper: =IF(A4="Add",B1+B4, IF(A4="Subtract",B1-B4)) Attached Images Last edited by jpsum; 09-29-2011 at 09:20 AM..
	Appreciate 0 Quote