?

[xyz1]

.

[jackhertel]

I might go with something like:

          IF("Project CPI"<0.9, ' OverBudget',

              IF("Project CPI">=0.9 and "Project CPI"<=1.0, 'Within Budget',

                  IF("Project CPI">0.9, 'Under Budget'

           ))) as CostClassification

FROM [lib://vvv/vvvv.xlsx]

(ooxml, embedded labels, table is Projects);

Put both conditions in the Withing Budget part of the statement with an 'and' Boolean operator.

[senpradip007 · Accepted solution]

Your might be wrong.

Try like:

IF("Project CPI"<0.9, 'Under Budget', IF("Project CPI" <=1, 'Within Budget', 'Over Budget' ))) as CostClassification

[xyz1]

.

[antoniotiman]

Hi Agrim,

add

Where [Project CPI] >= 0.9 and [Project CPI] <= 1;

Regards,

Antonio

[senpradip007]

Have a look at the attachment.