MichaelNaser

3 years agoQrew Trainee

# Working on Nested if Statement

Hi Everyone,

I was working on a currency formula, but it looks like my nested if statement does not work properly. The formula that I have now is

If([Reimburse Amount Override]>=0,[Reimburse Amount Override],

If([Category Requires # of 1-Way Trips Field],

If([Category - Multiplied by Mileage],

([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way],

([# of 1-Way Trips] * [Category Rate])

),

[Mileage Cost]+[Cost]

))

The problem here is that Override works fine, but when I put "cost" and l leave "Reimburse Amount Override" blank , it does not calculate the cost any more!

------------------------------

Michael Naser

------------------------------

I was working on a currency formula, but it looks like my nested if statement does not work properly. The formula that I have now is

If([Reimburse Amount Override]>=0,[Reimburse Amount Override],

If([Category Requires # of 1-Way Trips Field],

If([Category - Multiplied by Mileage],

([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way],

([# of 1-Way Trips] * [Category Rate])

),

[Mileage Cost]+[Cost]

))

The problem here is that Override works fine, but when I put "cost" and l leave "Reimburse Amount Override" blank , it does not calculate the cost any more!

------------------------------

Michael Naser

------------------------------