• Status: Solved
• Priority: Medium
• Security: Public
• Views: 30

# SharePoint Calculated Column Help

Trying to setup  calculated column in SharePoint with the following logic

if TCV GE 100000000 then = L0
if TCV GE 25000000 AND LT 100000000 then = L2
if TCV GE 5000000 AND LT 25000000 then = L3
if TCV LT 5000000 then = L4
if TCV EQ 1 then = L3
0
Matt Pinkston
• 4
1 Solution

Author Commented:
How to combine

=IF([TCV]>=100000000, "L0", "Not OK")

=IF(AND([TCV]>=25000000, [TCV]<100000000), “L2”, “”)

=IF(AND([TCV]>=5000000, [TCV]<25000000), “L3”, “”)

=IF([TCV]<5000000, "L4", "")

=IF([TCV]=1, "L3", "")
0

Author Commented:
Would this be right????

=IF([TCV]>=100000000, "L0", (AND([TCV]>=25000000, [TCV]<100000000), “L2”, (AND([TCV]>=5000000, [TCV]<25000000), “L3”, ([TCV]<5000000, "L4", ([TCV]=1, "L3", "")))))
0

Author Commented:
I get an error when trying to add the above
0

Commented:
All if statements should be inside one single brackets
like this

=IF(([TCV]>=100000000), "L0", "Not OK",
IF((AND([TCV]>=25000000, [TCV]<100000000), “L2”, “”,
IF((AND([TCV]>=5000000, [TCV]<25000000), “L3”, “”,
IF(([TCV]<5000000, "L4", ""),
IF(([TCV]=1, "L3", ""))))))

it should be something like this. reconstruct your statement, start with single then add another one after another. That way you can track when you are making mistake.
but the structure has to be like this.
0

Author Commented:
GREAT.... Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.