Skip to Content
3
Former Member
Jul 24, 2007 at 08:26 AM

Connect IFs

38 Views

Hi,

We have a problem, want connect many IF into the formula, that is,

IF Actual1 < Actual2 THEN Actual1

ELSE IF Actual1 < Actual3 THEN Actual1

ELSE IF Actual1 < Actual4 THEN Actual1

ELSE 0.

I saw into SAP Library that one IF is correct, but if I want many Ifs????

Example SAP Library:

IF Actual Costs > Plan Costs THEN Plan Costs + Plan Deviation ELSE Actual Costs

can be written as the following formula:

(Actual Costs > Plan Costs)* (Plan Costs + Plan Deviation) + (NOT (Actual Costs > Plan Costs)) * Actual Costs

Thank you very much.

Oscar