I need help with an Expression

[Stephen_Smith]

I can’t figure out what the issue is with my expression:

IF(AND([2nd Calculation]>0, [UTC_Date]>UTCNOW(),([Saving_Adjust]+[2nd #1])+(([2nd Calculation]-1)[2nd 2>])), IF(AND([1st Calculation]=0, [UTC_Date]>UTCNOW(), 0.00+[Saving_Adjust],([Saving_Adjust]+[1st #1])+(([1st Calculation]-1)[1st 2>]))))

Thanks for the help

[Lynn]

Hi @Stephen_Smith
What errors do you get when you test it?

[Stephen_Smith]

This is the error:

Condition AND(([2nd Calculation] > 0), ([UTC_Date] > UTCNOW()), (([Saving_Adjust]+[2nd #1])+(([2nd Calculation]-1)*[2nd 2>]))) has an invalid structure: subexpressions must be Yes/No conditions

[khuslid]

You miss a + here…
[Saving_Adjust]+[2nd #1])+(([2nd Calculation]-1)
+(missing)
[2nd 2>]

[khuslid]

Try this:
IF(
AND(
[2nd Calculation]>0, [UTC_Date]>UTCNOW(),
([Saving_Adjust]+[2nd #1])+(([2nd Calculation]-1)+[2nd 2>])
),
IF(AND([1st Calculation]=0, [UTC_Date]>UTCNOW(), 0.00+[Saving_Adjust],([Saving_Adjust]+[1st #1])+(([1st Calculation]-1)+[1st 2>]))))

[Stephen_Smith]

**Sorry somehow the “*” was cut off the post.

IF(AND([2nd Calculation]>0, [UTC_Date]>UTCNOW(),([Saving_Adjust]+[2nd #1])+(([2nd Calculation]-1)[2nd 2>])), IF(AND([1st Calculation]=0, [UTC_Date]>UTCNOW(), 0.00+[Saving_Adjust],([Saving_Adjust]+[1st #1])+(([1st Calculation]-1)[1st 2>]))))

[Stephen_Smith]

[khuslid]

Yes I see the problem.
If you use a AND(…) this must return a yes/no result.
But you have AND(
[2nd Calculation]>0,
[UTC_Date]>UTCNOW(),
([Saving_Adjust]+[2nd #1])…

But ([Saving_Adjust]+[2nd #1])… is not a Y/N result.

[khuslid]

Stephen_Smith:

IF(AND([2nd Calculation]>0, [UTC_Date]>UTCNOW(),([Saving_Adjust]+[2nd #1])+(([2nd Calculation]-1) [2nd 2>])), IF(AND([1st Calculation]=0, [UTC_Date]>UTCNOW(), 0.00+[Saving_Adjust],([Saving_Adjust]+[1st #1])+(([1st Calculation]-1) [1st 2>]))))

Not sure what you want to do here, but as an example, this should work:
IFS(AND(
[2nd Calculation]>0,
[UTC_Date]>UTCNOW()),
([Saving_Adjust]+[2nd #1])+(([2nd Calculation]-1)[2nd 2>]),
AND(
[1st Calculation]=0,
[UTC_Date]>UTCNOW(),
0.00>[Saving_Adjust]),
([Saving_Adjust]+[1st #1])+(([1st Calculation]-1)[1st 2>]))

[Stephen_Smith]

[Stephen_Smith · Accepted solution]

I figured it out

Thanks for all the help