SP Calculated Field Formula help

Why am I getting an error on this  calculated field formula?

=IF([TCV]>=100000000, "L0", (AND([TCV]>=25000000, [TCV]<100000000), "L1", "Not OK"))
Matt PinkstonAsked:
Who is Participating?
 
Matt PinkstonAuthor Commented:
I needed additional IF statements
0
 
IsaacSharePoint Client Side DeveloperCommented:
What's the error message you get?
0
 
Matt PinkstonAuthor Commented:
no nswer, figured out issue
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.

All Courses

From novice to tech pro — start learning today.