How to do ?

[Vince56190]

I would like to write a calculation like this
IF ( A < 2700 , "( ( A * 0.2766 ) - 190 ) ) )" , IF ( A > 2701, "( (A * - 0.2766 )-190 ) ) )"
did i do someting wrong ? this is to create a graph that goes up, peaks at 2700 and goes down

[RobertZenz]

The quotation marks are odd and some parantheses are off, as far as I can tell:

IF ( A < 2700 , ( ( A * 0.2766 ) - 190 ), IF ( A > 2701, ( (A * - 0.2766 )-190 ) ) )

I didn't test this, though.

[RobertZenz]

This should be correct:

IF ( A < 2700 , ( ( A * 0.2766 ) - 190 ), IF ( A > 2701, ( (A * - 0.2766 )-190 ), 2700 ) )

Slightly differently formatted:

IF(
	A < 2700,
	(A * 0.2766) - 190,
	IF(
		A > 2701,
		(A * - 0.2766) - 190,
		2700))